MIN function

K

Kevin G

I have a spreadsheet with columns "C" through "T" containing names in Row 2,
below that I have a formula to calculate the distance from one point to each
of the places named in Row2. What I'd like to do is find the lowest number
and then in cell C10 return the name associated with that lowest number.

Any help would be appreciated.

Thanks
 
D

David Billigmeier

So are your "min" numbers contained in row 3 then? If so, use this:

=INDEX(C2:T2,MATCH(MIN(C3:T3),C3:T3,0))
 
Top