software

I have a spreadsheet with columns quot;Cquot; through quot;Tquot; 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

So are your quot;minquot; numbers contained in row 3 then? If so, use this:

=INDEX(C2:T2,MATCH(MIN(C3:T3),C3:T3,0))--
Regards,
Davequot;Kevin Gquot; wrote:

gt; I have a spreadsheet with columns quot;Cquot; through quot;Tquot; containing names in Row 2,
gt; below that I have a formula to calculate the distance from one point to each
gt; of the places named in Row2. What I'd like to do is find the lowest number
gt; and then in cell C10 return the name associated with that lowest number.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks

David,

Thank you very much!! Worked like a champ.

Kevin

quot;David Billigmeierquot; wrote:

gt; So are your quot;minquot; numbers contained in row 3 then? If so, use this:
gt;
gt; =INDEX(C2:T2,MATCH(MIN(C3:T3),C3:T3,0))
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Kevin Gquot; wrote:
gt;
gt; gt; I have a spreadsheet with columns quot;Cquot; through quot;Tquot; containing names in Row 2,
gt; gt; below that I have a formula to calculate the distance from one point to each
gt; gt; of the places named in Row2. What I'd like to do is find the lowest number
gt; gt; and then in cell C10 return the name associated with that lowest number.
gt; gt;
gt; gt; Any help would be appreciated.
gt; gt;
gt; gt; Thanks