Hello Mentors,
I want to create a wheel (circle) in excel and spin it to find a luckiest one out of 350 names. Would it be possible to create such function?
I have done it with the help of formula (=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)) by keeping list of names in A column and it also finds the name randomly as I wanted. But, it didn't look good. I want to a wheel to spin and randomly pick a name then pop it out from the wheel.
Your support will be highly appreciated.
Thanks
I want to create a wheel (circle) in excel and spin it to find a luckiest one out of 350 names. Would it be possible to create such function?
I have done it with the help of formula (=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)) by keeping list of names in A column and it also finds the name randomly as I wanted. But, it didn't look good. I want to a wheel to spin and randomly pick a name then pop it out from the wheel.
Your support will be highly appreciated.
Thanks