Posted by Travis on January 28, 2002 9:59 AM
I'm trying to create a list of 10 random numbers from 1 to 10 without repeating any.
I am using the formula =ROUND(RAND()*10,0) to generate the numbers in each row, but I get several repeated values.
Is there a macro that could be written to check for duplicate values in the 10 cells, and if a duplicate is found then regenerate all the 10 numbers...looping until there are no duplicates.
Its going to be used for a super bowl pool. I realize I could draw out of a hat...but come on...thats no fun.