View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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