ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counter for Rows (https://www.excelbanter.com/excel-worksheet-functions/46792-counter-rows.html)

Liz

Counter for Rows
 
I'm making a large text database that prints onto 2 pages, and I need to
number each row in order to make it easier to locate items on both pages.
What kind of function (and exactly how do you do it?) do I need to make a
counter that automatically changes the numbers when I update information/add
cells?
Example:
1. Amber Grove Apts.
2. American River Apts... etc.

If I need to add something above #1, I want to number to change accordingly.
Help! Thanks, Liz



Duke Carey

if your data starts on row 2, for instance, use

=ROW()-1

if it starts on row 5, use

=ROW()-4

"Liz" wrote:

I'm making a large text database that prints onto 2 pages, and I need to
number each row in order to make it easier to locate items on both pages.
What kind of function (and exactly how do you do it?) do I need to make a
counter that automatically changes the numbers when I update information/add
cells?
Example:
1. Amber Grove Apts.
2. American River Apts... etc.

If I need to add something above #1, I want to number to change accordingly.
Help! Thanks, Liz




All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com