sequential cell numbers??

  • Thread starter Thread starter Gordon J. Rattray
  • Start date Start date
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
 
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
 
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
 
Back
Top