Execl formula return the lowest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What formula do I use to return the lowest value whether numeric or character
in the column?
 
Surely lowest can only apply to numeric, in which case it is just =MIN(A:A)
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return 2nd Lowest Value Q 10
INDEX MATCH SMALL 12
Formula to return lowest value of 3 datapoints 3
Trying to find additional ranges outside of min, max, and average 2
Extract the 2 Lowest % 3
Trying to subtract the two lowest values from a row of numbers 4
Formula Needed for lowest three values in a Column 12
find lowest number and return it's adjacent cell 7

Back
Top