PDA

View Full Version : Solved: Generate a random List of names from table



klutz
01-18-2011, 08:14 AM
Hi

Happy New Year everyone.

I was wondering if I could get some guidance here.

I have a table in excel that has names and country. From that one table i want to generate 5 smaller tables/list of the names but they cannot repeat.

Can this be done? :thumb

Klutz---out!!!!

p45cal
01-18-2011, 12:29 PM
See attachment.
Make your 6 tables by direct ref to the cells
Add a column D containing =RAND().
F9 to recalculate.
Sort columns BCD on column D.
Fix resultant tables by copy paste|values (in situ or elsewhere).
Sort table again by column C to restore original order.

http://www.box.net/shared/47qe403xgi

p45cal
01-18-2011, 12:29 PM
deleted

klutz
01-18-2011, 12:47 PM
Absoulutely grateful for your valuable help. I've opened the attachment and it does what is requested.

Saludos y Gracias.