Find the lowest value, and report back...

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have the following values (for example) just as they are in adjacent rows and columns (A1:C2). I
would like to find the lowest value of cells A2:C2, and then put the corresponding name in a cell
elsewhere on the sheet (say, A10). There also needs to be some error checking because cells A2:C2
can be set to "".

A B C
1 linus biff skippy
2 $100.00 $25.00 $20.00

This has stumped me for a while...I did get it to work when the lowest values were in columns A and
B, but a low value in C always defaulted to my default value of "N/A"

Thank you for you time,

Scott
 
=if(count(a2:c2)=0,"",index(a1:c1,match(min(a2:c2),a2:c2,0)))

would return the name with the minimum (only the first if there was a tie).
 
Dave said:
=if(count(a2:c2)=0,"",index(a1:c1,match(min(a2:c2),a2:c2,0)))

would return the name with the minimum (only the first if there was a tie).
Click to expand...
Oh Thank you, thank you...Dave!!
 
This should do the trick:

=IF(ISERROR(INDEX(B3:D4,1,MATCH(MIN(B4:D4),B4:D4,0))),"",INDEX(B3:D4,1,MATCH
(MIN(B4:D4),B4:D4,0)))

This may look a bit long, but will show nothing if ANY error occurs. For
example, if any of the numbers in B4:D4 were formulas that resulted in a
error, this function still shows nothing.

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
Back
Top