How to add a random number to a data sheet?

Copper Contributor

I am creating a data excel sheet and need to know how to create a column that randomly populates a number. Any ideas?

2 Replies
=RANDBETWEEN(1,10000)
Or with Excel 365 you can use =RANDARRAY(1000,1, 1, 999999,TRUE )