MIN function
 

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

MIN function
 

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

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


--
Regards,
Dave


"Kevin G" wrote:

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

MIN function
 

David,

Thank you very much!! Worked like a champ.

Kevin

"David Billigmeier" wrote:

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

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


--
Regards,
Dave


"Kevin G" wrote:

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