unique random number in excel
On Apr 3, 6:59 pm, SeanW. wrote:
I am using excel to make bingo cards. I am using the =randbetween(*,*)
formula to generate the numbers but I keep getting duplicate numbers. How can
I ensure that each cell will have a unique number?
1) In Column A, enter in the range of numbers you need eg. 1 through
25
2) In column B, enter =rand() and fill for as many rows as you have
values in column A
3) Hit F9 (calculate)
4) Select column B, copy, paste-special values only.
5) Sort by column B, now you have the values you want (column A) in a
random order and without dups.
Chris
|