You could use an array formula, entered with Ctrl-Shift-Enter:

=INDEX(C:C,MAX((C1:C1000<"")*(ROW(C1:C1000))))

This will return the 'lowest' value from the first 1000 rows of column C - by which I took to mean
the last entry in the column....

HTH,
Bernie
MS Excel MVP


"Excel Lowest Value" <Excel Lowest wrote in message
...
What formula do I use to return the lowest value whether numeric or character
in the column?