Hi,
I need excel to pick 3 separate names or cells from a list of a bout 20. The 3 names must be random and is important the same one does not repeat
Tried the random formula etc but no luck.
Any tips ? Thanks
Hi,
I need excel to pick 3 separate names or cells from a list of a bout 20. The 3 names must be random and is important the same one does not repeat
Tried the random formula etc but no luck.
Any tips ? Thanks
For a random list with no duplicates:
Put your range of names in column A (A1:A20 in your example)
in B1:B20 put =RAND()
in C1:C20 put =INDEX(A$1:A$20,MATCH(SMALL(B$1:B$20,ROW()),B$1:B$20,0))
Use the values results in column C1:C3
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
You could also do something like this.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Having your random numbers in the A column, and your names in the B column
Who needs a life when you have Excel.
Hi Both,
Both are just what I need. Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks