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
|