Steps to randomly select names for drawings

C

Cindi

I would like to select individual names from a database of
names randomly for a drawing. Can someone send me the
steps.
 
P

Peo Sjoblom

One way..

Assume the names are in A2:A200, copy the name list to a
new sheet.. In B2 put

=RAND()

copy down to B200.. Now sort on column B ascending..
Select the first x number of names in column A
That would be your random selection for the drawing..

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio to Excel 0
Weekly Report 2
Visio 2019 crashes when attempting to open drawing. 0
random draw from list of names 1
Multi-Selection with Hand-writing draw tool 0
Crating User Form to Add Names 1
Word does random actions (Mac) 0
Migrate Power Bi Tenant to Office 365 Step by Step Guide or best route to take 0

Top