Formula in Microsoft Excel

[Chris100682]

I am trying to write a formula in Excel that will choose a random name from a list of names. I have 32 names in a list and want to random select one of them - Bit like a lucky dip! How would I go about it? I know how to do a random search on a value but a name isn't having it, Please help before i smash the PC up!!

[kempie]

If the names are in individual cells in the style A1, A2, A3... A31, A32 then this should work

=INDIRECT("A"&INT(RAND()*32)+1)

• A is the column the list is in
• 32 is the length of list
• 1 is the row where the list starts

these can be changed for a list of another size or position.