Excel formula for tracking ticket sales in increments of 25

[ButterkupInc]

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?

 

[James Mason]

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.

 

[ButterkupInc]

Thank You!!!!

 

[EasyLover]

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

 

[James Mason]

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

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.