# Excel formula for tracking ticket sales in increments of 25

#### ButterkupInc

##### Estimable
I need to keep track of 3200 raffle tickets.
I want to list them in increments of 25, then record WHO got which NUMBERED ticket.
Beginning at 0001-0025, cell A1
0026-0050, cell A2
all the way to 3200
How do I do this?

Solution
A1: =CONCATENATE(B1,"-",C1)
B1: 1
C1: 25
A2: =CONCATENATE(B2,"-",C2)
B2: =B1+25
C2: =C1+25

Select everything you've entered then use the fill handle (there's a little black sqaure in the bottom right of your selection, click and hold that) and drag down till you reach 3200.
You can hide Columns B and C afterwards.

There's probably a more seemless way to do it but I don't want to figure out how to make it a nested table right now, this is the simplest method.

#### James Mason

##### Honorable
A1: =CONCATENATE(B1,"-",C1)
B1: 1
C1: 25
A2: =CONCATENATE(B2,"-",C2)
B2: =B1+25
C2: =C1+25

Select everything you've entered then use the fill handle (there's a little black sqaure in the bottom right of your selection, click and hold that) and drag down till you reach 3200.
You can hide Columns B and C afterwards.

There's probably a more seemless way to do it but I don't want to figure out how to make it a nested table right now, this is the simplest method.

Thank You!!!!

#### EasyLover

##### Honorable
Good formula. You can do the trick through macro with processing at back end as well.

#### James Mason

##### Honorable

Writing a whole macro is usually more work though, a macro is a probably to complicated of a way to solve this simple problem. A macro is good if you need it to think, but this was just simple addition.

Replies
3
Views
2K
Replies
1
Views
6K