automatically number every other row

K

KGB

Hi, I need to be able to number every other row on my spread sheet. The
numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is this
possible? Thanks
 
R

Ron Coderre

Try something like this:

A1: Blank
A2: =IF(ISNUMBER(OFFSET(A2,-1,0)),"",MAX($A$1:OFFSET(A2,-1,0))+1)
copy that formula down as far as you need.

It will number every other cell, beginning with 1 in A2.

If you enter a number in A1, the numbering will resequence.
Also, you can insert rows without throwing off the sequencing.

Experiment with it, changing references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
R

Roger Govier

Hi

One way
Enter a 1 in A1, 2 in A3.
Mark cells A1:A4.
Grab the fill handle (the small black cross that appears as you hover
over the bottom right corner of cell A4) and drag down as far as you
need.
 
G

Gary''s Student

Using column A. In A1 enter:
=IF(ISEVEN(ROW()),"",(ROW()+1)/2)
and copy down
 
Top