There are any number of formulas you can use in column A that will return a row number.
Perhaps the easiest is to use the ROW function, like this:
=ROW( )
This formula returns the row number of the cell in which the formula appears.
If you want to offset the row number returned (for instance, if you have some headers in rows 1 and 2 and you want cell A3 to return a row value of "1", then you can modify the formula to reflect the desired adjustment:
=ROW( )-2
Of course, the ROW function isn't the only formula that will perform this function. Look for more Go Ask Debbie Tips on using Excel formulas and functions directly at Go Ask Debbie.
Subscribe to:
Post Comments (Atom)
-
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?... -
I've had a few people ask me lately how to filter lists using Excel. It really is as simple as clicking a button on the Ribbon. If you...
-
When Outlook is first setup, the default Auto-Archive is 6 months. This means that e-mails dated 6 months ago will automatically be moved...
No comments:
Post a Comment