Excel Formula - Reg

M

Muralidhar.L

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
Murali
[email protected]
 
M

Max

Assuming data is in row1,
in the structure: number, text, number, text, ...
and there are no ties in the min value

Eg in A1 across are: 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
 
Top