sequential cell numbers??

G

Gordon J. Rattray

Hi there,

I'm trying to print up a batch of tickets using each cell as a ticket.

What I need to do is start with the number 1, and each successive cell
automatically puts the number 2, 3, 4, and so on ....

How can I do that?

Thanks,

Gordon
 
F

Frank Kabel

Hi
the following formulas will put a sequencing number in column A, if
column B is filled:

in A1 enter the following formula
=IF(B1<>"",1,"")

in A2 enter the formula
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like
 
N

nca77

if you are starting in cell A1

Type the number 1 in A1

then in A2 type =A1+1

then copy that formula down as far as you want to g
 
Top