What is the formula to generate a random name? I have 1000 students records and I'd like to have for each row a student name randomly.
Is there a formula to generate that?
Thanks.
What is the formula to generate a random name? I have 1000 students records and I'd like to have for each row a student name randomly.
Is there a formula to generate that?
Thanks.
Generating a random list of names with no repeats
in A1:A1000 put the names
in B1:B1000 put =RAND()
in C1:C1000 put =INDEX(A$1:A$1000,MATCH(SMALL(B$1:B$1000,ROW()),B$1:B$1000,0))
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.
Not accurate. I'd like to have the name being generated and not putting the name.
Maybe with this
Enter formula in C2
Formula:Please Login or Register to view this content.
v A B C D 1 Names Random Name 2 John Lisa Press F9 to change names 3 Steve 4 Luke 5 Mary 6 Lisa 7 Jennifer 8 Mark 9 Alex 10 Brian 11 12
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks