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)
-
Many people are familiar with online e-mail accounts that provide access from anywhere you have Internet access. These accounts include G...
-
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ... -
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?...
No comments:
Post a Comment