![]() |
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 |
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