BrandykinsGamer
New Member
- Joined
- Nov 12, 2017
- Messages
- 9
Hello -
I want to create a spreadsheet for a video game 50/50 drawing that I am in charge of weekly.
And I need an easier way to assign the ticket numbers.
So basically tickets are 2K per ticket. But if you buy 5 tickets, you get 1 free.
I want a spreadsheet that has three columns: Name, Amount Rec'd, and Ticket #
But column 3 is going to need to assign the next row of ticket #s based on the previous row's numbers.
So let's say I have three people that buy tickets: Sally, John, and Betty
The rows would need to be displayed as follows:
Row 1: Sally, 10K, 1-6
Row 2: John, 2K, 7
Row 3, Betty, 20K, 8-19
So I need C1 to calculate the # of tickets to assign based on sales from B1.
Then I need C2 to calculate the # of tickets to assign based on sales from B2 but then look at C1 to know which ticket # it should start with next.
Does that make sense? Or is there an easier way to do this?
I want to create a spreadsheet for a video game 50/50 drawing that I am in charge of weekly.
And I need an easier way to assign the ticket numbers.
So basically tickets are 2K per ticket. But if you buy 5 tickets, you get 1 free.
I want a spreadsheet that has three columns: Name, Amount Rec'd, and Ticket #
But column 3 is going to need to assign the next row of ticket #s based on the previous row's numbers.
So let's say I have three people that buy tickets: Sally, John, and Betty
The rows would need to be displayed as follows:
Row 1: Sally, 10K, 1-6
Row 2: John, 2K, 7
Row 3, Betty, 20K, 8-19
So I need C1 to calculate the # of tickets to assign based on sales from B1.
Then I need C2 to calculate the # of tickets to assign based on sales from B2 but then look at C1 to know which ticket # it should start with next.
Does that make sense? Or is there an easier way to do this?