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