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!!!
