Last cell in column
 

If you don't know if its numeric or text, try
=INDIRECT("B"&MAX(IF(NOT(ISBLANK(B1:B100)),ROW(1:1 00)

which is an array formula, so enter with CTRL-SHIFT-ENTER

If you know it is numeric, this non-array formula works
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))

use this for text
=INDEX(B:B,MATCH(REPT("z",10),B:B,1),1)

--

HTH

Bob Phillips

"Apfreight" wrote in message
...
Searching for a command that will show me the LAST value in a column. Not
the
largest, but the last. Any help0 greatly appreciated.