Forum Discussion
Solved
Unique(RANDBETWEEN) errors
https://d.docs.live.net/d97f1549c90a579a/Documents I am trying to create a Random List between 1 and 21 in Excel I am in Spain, so it seems I have to change the Comma for a semi-colon. This is my ...
The file cannot be access without a login!
RANDBETWEEN generates a single number, so UNIQUE serves no purpose here. The numbers in the red outlined area are not connected in any way. The are just 21 unrelated random numbers between 1 and 21.
Use RANDARRAY to generate 21 random numbers. Don't use integers!! Then use SORTBY to generate a random list of Horse Names.
The file cannot be access without a login!
RANDBETWEEN generates a single number, so UNIQUE serves no purpose here. The numbers in the red outlined area are not connected in any way. The are just 21 unrelated random numbers between 1 and 21.
Use RANDARRAY to generate 21 random numbers. Don't use integers!! Then use SORTBY to generate a random list of Horse Names.