software

I have a matrix with 1 row and 20 columns, the couple cells contain a numeric
value and an associated text in the next column, like this there are 15
couple of sets.

Now using Min(Value1,Value2..,) i can find the min of all the numeric
values, but how to get the text coupled with the minimum value?

Regards
MuraliAssuming data is in row1,
in the structu number, text, number, text, ...
and there are no ties in the min value

Eg in A1 across a 1, Text1, 2, Text2, 0.9, Text3, ...
(corresponding text to the right of the number)

Put in say, A3: =INDEX(1:1,MATCH(MIN(1:1),1:1,0) 1)

A3 will return the text coupled with the min value
For the sample data, A3 will return: Text3

If there are ties in the min value,
A3 will return the text next to the first* min value
*first from the left
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Muralidhar.Lquot; gt; wrote in message
...
gt; I have a matrix with 1 row and 20 columns, the couple cells contain a
numeric
gt; value and an associated text in the next column, like this there are 15
gt; couple of sets.
gt;
gt; Now using Min(Value1,Value2..,) i can find the min of all the numeric
gt; values, but how to get the text coupled with the minimum value?
gt;
gt; Regards
gt; Murali
gt;