MrExcel Publishing
Your One Stop for Excel Tips & Solutions

The Last One


Posted by Ed Blunk on February 08, 2002 9:25 AM

How do I find a value that would represent the last populated cell in a vector interspersed with unpopulated cells? From time to time, more cells in the vector will be populated and I will need to always find the current last or bottom populated cell. I need to link this last value into a summary page without disturbing the organization of the data on the source page(s).


Posted by Aladin Akyurek on February 08, 2002 10:21 AM

I'll take a vector to mean just a coloumnar range of numeric type. If this supposition is right, you can use:

=INDEX(SourcePage!A:A,MATCH(9.99999999999999E+307,SourcePage!A:A))

Substitute the real sheet name for "SourcePage".

===========

Posted by Ed Blunk on February 11, 2002 12:27 PM

I'm impressed. This does just the trick. THANKS!!!