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
|