raffle

  1. tezza

    Dynamically extend list help

    Hi, I'm in the process of setting up a raffle generator and prize winner. Step 1 : Enter Name and how many tickets they've bought Step 2 : Create a dynamic list of names and tickets numbers depending on how many tickets are purchased per person Step 3 : Allow someone to hit a button to...
  2. W

    Raffle Draw with Multiple Prices

    Hi, I am making an online raffle drawer for a lottery with multiple prices, and have assembled one based on what I could find on google and YouTube. I have a button with a VBA code which picks winner 1,2,3 etc in consecutive order (see worksheets below). However, I need to remove the ticket for...
  3. C

    IF

    Could someone please confirm best formula for MINIMUM CHARGE - £ 5,000 IF A RAFFLE DOESN'T REACH £ 5,000 THEN THE AMOUNT COLLECTED ROLLS OVER I.E. RAFFLE - £ 2000 FORMULA CALCULATES THAT £ 3000 ROLLS OVER Also I have a formula tab with workings and styles i.e. cell sizes but when I copy...
  4. E

    Performing two functions with one click, rand() and sort

    Hello Everyone, First time poster! I am conducting a raffle at work. I have a list of 100 people and a number associated with each one. The number next to their name will correlate to a number in a raffle basket. There will be multiple raffles and each raffle the numbers need to be randomized...
  5. F

    Raffle Number Values (300+) live and linked in AutoFormat/Smartart. I need suggestions.

    First post, used this site in the shadows throughout my career. The local alumni association use old, physical, heavy boards to display numbers 1-300 for a reverse raffle; last number pulled wins pot, prizes along the way. I currently have a neat workbook, I need to have numbers still playing...
  6. C

    random unique numbers/ names put into a grid - help needed

    I am doing a cow patty drop for my local non-profit community group. We are selling tickets (numbered 101-676) for the event. In order to show who's name ends up where in the tennis court that will be marked in a 24 x 24 grid, I would like to show each ticket number (or preferably the...
  7. S

    Excel automated raffle draw

    Hi all, I know how to randomly select a name from a list in excel but what I would like to do is be able to click a start button in excel that generates a 5-10 second message before announcing the winner i.e Are you ready........and the winner of the Ipod is...........randomly generated name...

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