Anyone an Excel whiz?

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • heitkamp94
    MVP
    • Dec 2004
    • 1285

    #1

    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.
  • Trevytrev11
    MVP
    • Nov 2006
    • 3259

    #2
    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.

    Comment

    Working...