ExcelBanter - Formula to display the row number above?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to display the row number above? (https://www.excelbanter.com/excel-worksheet-functions/90873-formula-display-row-number-above.html)

[email protected]

Formula to display the row number above?

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

David Billigmeier

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

All times are GMT +1. The time now is 07:10 PM.