View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jayceejay jayceejay is offline
external usenet poster
 
Posts: 24
Default Auto number Non null values

Column A contains row numbers ONLY if there is a corresponding value (text)
in column B.
Is there a function that will do this for me? It needs to re-increment when
a row is added in the middle, much like numbered bullets reconfigure. Right
now, the best I can do is apply a row number whether there is a value there
or not. All I want is an incremented counter in column A for any row in
which I enter a text value in column B. I would appreciate ANY help!