More Links

heitkamp94 · 05-15-2008, 06:08 PM

I was wanting know if there was a way through excel to have it randomly generate an order for a group of names i put in. Kind of like drawing names out of hat. I'm not sure if this can be done, and I'd appreciate the help if you know how to do this or for another option besides excel.

Trevytrev11 · 05-15-2008, 10:05 PM

Use this formula:

=INDEX(A:A,ROUND(RAND()*COUNTA(A:A),0))

This assumes that your list of names is in column A.

To randomly choose a new name, you can just hit F9/Enter, etc.

Let me know if you have any questions.

05-15-2008, 06:08 PM	#1
heitkamp94 MVP OVR: 9 Join Date: Dec 2004 Location: Southwest Iowa	Anyone an Excel whiz? I was wanting know if there was a way through excel to have it randomly generate an order for a group of names i put in. Kind of like drawing names out of hat. I'm not sure if this can be done, and I'd appreciate the help if you know how to do this or for another option besides excel.

05-15-2008, 10:05 PM	#2
Trevytrev11 MVP OVR: 19 Join Date: Nov 2006	Re: Anyone an Excel whiz? Use this formula: =INDEX(A:A,ROUND(RAND()*COUNTA(A:A),0)) This assumes that your list of names is in column A. To randomly choose a new name, you can just hit F9/Enter, etc. Let me know if you have any questions.

	MLB The Show 24 Review: Another Solid Hit for the Series
	New Star GP Review: Old-School Arcade Fun
	Where Are Our College Basketball Video Game Rumors?

More Links

Anyone an Excel whiz?