J jskushawah New Member Sep 24, 2012 #1 I have a name list in A2:A15, I want to choose one name randomly using choose function, how will it possible ???
I have a name list in A2:A15, I want to choose one name randomly using choose function, how will it possible ???
Faseeh Excel Ninja Sep 24, 2012 #2 Hi Jskushawah, You can use: Code: =INDEX(A2:A15,RANDBETWEEN(2,15),0) Press F9 to recalculate things. Regards, Faseeh
Hi Jskushawah, You can use: Code: =INDEX(A2:A15,RANDBETWEEN(2,15),0) Press F9 to recalculate things. Regards, Faseeh