I have a simple spreadsheet listing 249 names. Columns are: Number, First Name, Last Name (36, John, Doe) I need to randomly choose 12 names each day. I created a simple RANDBETWEEN function and coppied it into 12 cells so I get 12 numbers everytime the sheet is opened. I then have to look at the names that are in the appropriate row. I'd like to have it actually show the correct name next to the randomly generated number. 7 John Doe, 36 Tim Smith, 44 Bill Perkins. Is that possible?
Take a look to VLOOKUP or INDEX & MATCH functions.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The easiest way to do this is...
If you have 249 rows of data, say A1:C249. Enter this formula in D1 and copy down to D249:
=RAND()
Select the entire range A1:D249 and do a sort on column D. You can sort in either direction, ascending or descending, it doesn't matter.
Now, take the top 12 rows for your random selections.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tok a little tweaking but VLOOKUP did it. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks