Been scouring the Internet, and I can't seem to find an answer to my question. Is there a formula that I can put into a range of cells that will populate the cells with random names from a list...without duplicates?
For example:
I have a list of names in Sheet 2:Column A.
In Column C:Sheet 1, I want a random selection of all of the names listed on Sheet 2...without duplicates.
Then in Column D:Sheet 1, I want another list.
Then, again...in Column E:Sheet 1. And so on.....
I use the following array formula to populate each column:
=INDEX(Sheet2!A:A,ROUNDUP(RAND()*COUNTA(Sheet2!A:A),0))
...but, I get duplicates. What am I missing?
I sure hope someone can help me with this...
Bookmarks