Returning a text in a =min function

Hi all,

I have 3 columns of numerical data. In my fourth column, I would like to return the minimum value from the 3 previous columns (=min). However, instead of returning the lowest number, I would like it to return the column title (=text) of the lowest number. I haven't been able to locate a function that does this. I'd appreciate any help.

Try this in D2 to evaluate A2:C2 and return the text value from A1:C1.

=INDEX($A$1:$C$1, MATCH(MIN($A2:$C2), $A2:$C2, 0))

...then copy that down.

Hi

You can use following formula =MAX(A1,B1,C1)

Rahul

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)