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. Referencing Data in Another Excel Workbook Q: Joe, I have data in another workbook that I...
3. Excel Concatenate Function The Excel concatenate function can be used to combine multiple...
4. Excel CELL () Function The CELL function can be used to find out information...
5. Using Right() and Left() Functions to Remove Text from a String - Excel Today I came across a problem I see at least...