Forum Discussion
LIFESKILLS
Nov 10, 2020Copper Contributor
How to add a random number to a data sheet?
I am creating a data excel sheet and need to know how to create a column that randomly populates a number. Any ideas?
- =RANDBETWEEN(1,10000)
- Or with Excel 365 you can use =RANDARRAY(1000,1, 1, 999999,TRUE )