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?... -
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...
-
Are you Left Handed? I mean truly Left-Handed, meaning you write and use the mouse with your Left Hand? If you are and you haven't setup...
No comments:
Post a Comment