View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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