Excel formula for tracking ticket sales in increments of 25
Tags:
- Windows 7
- Excel Formula
Last response: in Apps General Discussion
ButterkupInc
September 5, 2014 11:54:25 AM
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.
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.
-
Reply to James Mason
m
0
l
ButterkupInc
September 5, 2014 6:51:17 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.
-
Reply to James Mason
m
0
l
!