Excel formula for tracking ticket sales in increments of 25

ButterkupInc

Estimable
Sep 5, 2014
2
0
4,510
0
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

Honorable
Moderator
Jan 2, 2014
106
0
10,710
25
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
Moderator
Jan 2, 2014
106
0
10,710
25
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
Moderator
Jan 2, 2014
106
0
10,710
25


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.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
H Apps General Discussion 13
U Apps General Discussion 1
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
C Apps General Discussion 7
S Apps General Discussion 3
M Apps General Discussion 11
indyitguy Apps General Discussion 8
wanamingo Apps General Discussion 1
E Apps General Discussion 1
GOM3RPLY3R Apps General Discussion 6
Christopher Chung Apps General Discussion 4
S Apps General Discussion 4
G Apps General Discussion 1
E Apps General Discussion 3
A Apps General Discussion 1
R Apps General Discussion 2

ASK THE COMMUNITY

TRENDING THREADS