Tracking Ticket Sales & Assigning Ticket #s

[BrandykinsGamer]

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?

 

[DRSteele]

Welcome to the Forum,

I expect what you meant was that for every five tickets purchased the buyer will receive a bonus ticket.

	A	B	C	D	E	F	G	H	I
1	price	2
2	bonus hurdle	5
3
4			tkts	bonus tkts	total tkts	begin#	end#		sequence
5	Sally	10	5	1	6	1	6		1 - 6
6	John	2	1	0	1	7	7		7
7	Betty	20	10	2	12	8	19		8 - 19

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet41​

Worksheet Formulas Cell Formula G5 =IF(E5=1,F5,E5+F5-1) C5 =B5/$B$1 D5 =TRUNC(C5/$B$2) E5 =D5+C5 C6 =B6/$B$1 D6 =TRUNC(C6/$B$2) E6 =D6+C6 C7 =B7/$B$1 D7 =TRUNC(C7/$B$2) E7 =D7+C7 F6 =G5+1 G6 =IF(E6=1,F6,E6+F6-1) F7 =G6+1 G7 =IF(E7=1,F7,E7+F7-1) I5 =IF(G5=F5,G5,"1 - "&E5) I6 =IF(G6=F6,G6,F6&" - "&G6) I7 =IF(G7=F7,G7,F7&" - "&G7) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>