Make a Raffle list in Excel

**office_gal** · 01-02-2010, 03:06 PM

Hello! I'm trying to make a raffle list for our office raffle in Excel. I want Excel to automatically update the number list based on the quantity of tickets each associate paid for.

Example:
Doug buys 3 tickets and Mike buys 5 tickets
The raffle list now looks like:
1 Doug
2 Doug
3 Doug
4 Mike
5 Mike
6 Mike
7 Mike
8 Mike

Then Sally buys 1000 tickets so 1000 tickets are added to the list, making 1008 the total number of tickets sold. This would update the list automatically if I entered "1000" for Sally's name, thus duplicating her name 1000 times in the list.

How can I do this automatically in excel so I won't have to use a calculator and do it manually. Thanks.

**somesoldiers** · 01-02-2010, 03:17 PM

not entirely sure what you need but try the attached and let me know if it works for you?

**shg** · 01-02-2010, 03:28 PM

If you take the sheet that somesoldiers posted, in C1 and copy down,

=SUM(B$1:B1)

Then on Sheet2 in A1 and copy down,

=INDEX(Sheet1!A:A, MATCH(ROW(), Sheet1!C:C) + 1)

**office_gal** · 01-02-2010, 04:25 PM

I did that but it won't list out all the tickets they bought. I'm using Excel 2002 so that may be the reason it won't work.

When I randomize all the numbers (say 1,008) at the end of the raffle, I want their number to be by their name. Example:

Doug bought 3 tickets
Mike bought 5 tickets
Sally bought 1,000 tickets

so the list looks like:
1 Doug
2 Doug
3 Doug
4 Mike
5 Mike
6 Mike
7 Mike
8 Mike
9-1008 Sally (but listed out)

Then if I go to randomizer.org and randomize 1 set of unique numbers 1-1008 and let's say a 50 is rolled, then Sally would be the winner and further down on the list it would say:
49. Sally
50. Sally -W i n n e r
51. Sally
-continued to 1008.

I hope that makes sense. I have 200+ people that have purchased a total of 50,000 tickets so this is a pickle of a problem.

Thanks so much for helping me.

**shg** · 01-02-2010, 04:54 PM

You don't need any of that to do this:

Please Login or Register  to view this content.

**office_gal** · 01-02-2010, 05:05 PM

Wow that's cool. Is there a way to still list out everyone's number by their name in a 2nd sheet? I have ignorant co-workers that want a visual representation of the raffle which is why I need to print out everyone's name by their numbered ticket.

**shg** · 01-02-2010, 05:19 PM

See attached.

**Huron** · 01-02-2010, 06:14 PM

I think the formula in B6 should be

Please Login or Register  to view this content.

Similarly on sheet 2 it should be

Please Login or Register  to view this content.

**shg** · 01-02-2010, 06:17 PM

Good catch, Huron, thank you.

**Rob_oli** · 01-31-2013, 08:16 PM

Thanks so much for this I have 13,000 ticket draw with 121 ticket holders this is brilliant.

**gardnt1** · 03-10-2013, 12:13 AM

Hi guys - new to forum and have been trying to create a file in excel for an upcoming raffle, similar to the one posted here.

added another few items, but problem i have is on sheet 2 when i am trying to make it list multiple entries for names :

this is the one i am trying to create:

**arlu1201** · 03-11-2013, 02:17 AM

gardnt1,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**inthezone969** · 08-22-2013, 11:25 PM

Hi,

How do I shg's excel sheet but to pick 22 winners?

Thank you

**arlu1201** · 08-23-2013, 08:53 AM

Inthezone,

Check post 12.

**coachhines01** · 10-29-2013, 12:16 AM

not sure if I can do this, but how do you list all tickets and no manes, and track each ticket #?

**arlu1201** · 10-29-2013, 12:57 AM

coachhines01,

Please check post 12. The post just above yours said the same thing too.

**LIannucci** · 04-29-2014, 11:26 AM

Hi ..I have just found this thread and its exactly what I need .. problem is I am not sure how to randomize and pick a winner .. is there a special function I have to do within the excel file?

**shg** · 04-29-2014, 11:45 AM

See the workbook at https://app.box.com/s/5a06b6he6sc9ce89bbfl for an updated version. Press F9 to recalculate.

**Xx7** · 04-29-2014, 01:04 PM

Old thread... but anyways, enter your Name and number of tickets in B4 and B5. Then click the button.

Please Login or Register  to view this content.

**bhunt0607** · 05-18-2017, 12:20 PM

This was so helpful! I just don't understand how you extend the formula in row c.

**interestme** · 11-20-2021, 06:41 AM

Thank you so much. This helped me out massively. You guys are life savers!! Appreciate it. Keep up the good work!

Make a Raffle list in Excel

LinkBack

Thread Tools

Rate This Thread

Display

Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Re: Make a Raffle list in Excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions