Returning Last Value In 2 Colums

[Tyler_Durden]

I would like to get the last value in column A & B and place them into another sheets cell. The number of rows will always be changing too.. In the attached spreadsheet I want the totals, which is the very last value in the colums. I’m still new with VBA but I think it has to have something like this..

Please Login or Register  to view this content.

But not sure, thanks for your help!


Attached is a sample Spreadsheet...

[Richard Buttrey]

Hi,

You don't necessarily need a macro

Please Login or Register  to view this content.

will do it.

Otherwise if you do need a macro

Please Login or Register  to view this content.

Rgds

[JBeaucaire]

=INDEX(example!A:A,COUNTA(example!A:A),1)

I love that formula, Richard. Bravo.

[Tyler_Durden]

Wow that formula is great! I appreciate your quick response!

[Richard Buttrey]

Thanks JB
The simple ones are always the best.
Trouble is finding 'em

Rgds

[NBVC]

Although, if there are blank rows in A:A, you may have a problem... it will not get the last entry unless those blank cells contain spaces...

[Richard Buttrey]

Indeed. Good point which I'd overlooked.

Maybe better

Please Login or Register  to view this content.

Rgds

[NBVC]

Or just:

=Lookup(9.999999999e+307,A:A)




And that is assuming values in A:A are numeric..

[Richard Buttrey]

....even better.