Last value in column (2007)

Topic

New Reply

How can I find the last value (entry) in a column?
A1-B?? (the last entry in column

Reply | Quote

Replies

Do you want to use a formula of VBA code?

If you want to use a formula and if column B contains numeric values, you can use this formula:

=INDEX(B:B,MATCH(9.99999999999999E+307,B:)

9.99999999999999E+307 is the largest value you can enter in an Excel cell, so presumably all values in your column B are smaller. The MATCH function will keep on searching until it reaches the last filled cell in column B, and return its row number. INDEX uses this to return the value of that cell.

Reply | Quote

Thanks Hans, that works quite well!
(hopefully the max number you mentioned will not be exceeded. . .this is for my weight loss program)

Reply | Quote

That depends on the unit…

Reply | Quote

LOL

Reply | Quote