Subscribe!

Reader Writes:

Joseph,

I have a spreadsheet set up where I enter all of my companies “packages shipped” data. I would like to know the value of the last row that I inputted. So, if column A contains packages shipped on each row, I want to know the last number entered in column A.

Thanks,
Carl
…………………………………………

Carl,

You can find the last cell containing data in column A using the following function:
=INDEX(A:A,(MATCH(9.99999999999999E+307,A:A)))
This can be used when numbers are involved. The formula would change if there are numbers and text.

Similarly, you can find the location of the last cell (what row it is on) using the interior part of the formula above…=MATCH(9.99999999999999E+307,A:A)

Joseph Harris
Excel Help
More Excel Help

Related posts:

  1. Automatic Updating “Dynamic” Charts in Excel One of the most time consuming parts of producing a...
  2. Excel Concatenate Function The Excel concatenate function can be used to combine multiple...
  3. Referencing Data in Another Excel Workbook Q: Joe, I have data in another workbook that I...
  4. Excel CELL () Function The CELL function can be used to find out information...
  5. Vlookup – My Favorite Function Vlookup...

This entry was posted on Monday, February 16th, 2009 at 2:05 pm and is filed under Excel Quick Tricks, Mail Bag. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.