Spin Wheel and get name

pranamu

Board Regular
Joined
Nov 2, 2011
Messages
56
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
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Wheel Decide

Max of 100 names so 5 spins in total.

Grp1 - Names 1 - 100
Grp2 - Names 101 - 200
Grp3 - Names 201 - 300
Grp4 - Names 301 - 350

Grp5 - Grp1 - Grp4 Winners
 
Last edited:
Upvote 0
Appreciate your quick reply Comfy.

I really didn't understand your answer. Please can you describe in details? Can it be done through excel?

Thanks.
 
Upvote 0
My suggestion is to not use Excel.

The spinning of a wheel is possible with VBA but your requirement is more complicated (Take list of names from A:A, Have a pop-out animation)
 
Upvote 0
My suggestion is to not use Excel.

The spinning of a wheel is possible with VBA but your requirement is more complicated (Take list of names from A:A, Have a pop-out animation)


And How do I pop-out animation? I can follow your guidelines to make it happen through VBA.
Please can you guide me in details.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top