View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default Formula to display the row number above?

Just the row number? This will work:

=ROW()-1


--
Regards,
Dave


" wrote:

Hi. I want to put a formula in a cell that will display the row number
above the cell. Any ideas on that? I was surprised a google search
yielded nothing.

Thanks!

Ken