automatically number every other row
 

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

automatically number every other row
 

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


"KGB" wrote:

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

automatically number every other row
 

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.

--
Regards

Roger Govier


"KGB" wrote in message
...
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

automatically number every other row
 

Using column A. In A1 enter:
=IF(ISEVEN(ROW()),"",(ROW()+1)/2)
and copy down
--
Gary's Student


"KGB" wrote:

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