What formula do I use to return the lowest value whether numeric or character in the column?
E Excel Lowest Value Jul 25, 2006 #1 What formula do I use to return the lowest value whether numeric or character in the column?
B Bob Phillips Jul 25, 2006 #2 Surely lowest can only apply to numeric, in which case it is just =MIN(A:A)
B Bernie Deitrick Jul 25, 2006 #3 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
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
