Sign in with
Sign up | Sign in
Your question

Excel formula for tracking ticket sales in increments of 25

Tags:
  • Windows 7
  • Excel Formula
Last response: in Apps General Discussion
Share
September 5, 2014 11:54:25 AM

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?

More about : excel formula tracking ticket sales increments

a b $ Windows 7
September 5, 2014 4:18:22 PM

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.
m
0
l
September 5, 2014 6:51:17 PM

Thank You!!!!
m
0
l
a b $ Windows 7
September 5, 2014 11:02:05 PM

Good formula. You can do the trick through macro with processing at back end as well.
m
0
l
a b $ Windows 7
September 6, 2014 12:55:41 PM

EasyLover said:
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.
m
0
l
!