random draw from list of names

J

jat

i want to do a draw from a list of names. some names appear multiple times
because it is a ballot draw. is there a function where i can shuffle the
names and then have excel randomly draw a name?

i tried randombetween but right now the names are in order and one name
keeps coming up repeatedly.

any suggestions would help,

thank you,

jat
 
M

Mike H

Hi,

Put the formula
=RAND()
in an adjacent column and sort the banes and this column and the name at the
top will be random.

Mike
 

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

Random Draw 4
Multiple List Analysis 0
Random Names and Command Button 1
How to make a column of cells have a drop down menu 3
Return Names From List 2
create a random list of names from a list of names in EXCEL 2
Random Selection 3
Exclude Range from Random Name Generator 2

Top