Returning Header from Minimum Value

[october1702]

Hi There.

I have created a worksheet with headers on each column each has different and used the =MIN function to find the lowest value. All good so far.... Now instead of returning the value I would like it to return the header text.

For Example.

Four columns Tom Paul Harry Bob

Tom has a value of 10 in the cell below.

Paul has a value of 5 in the cell below. and so on with Harry and Bob

Using the =MIN(A3:D3) I get the lowest value (in this case)5. I want to the returned value as Paul instead of 5. Is this possible and if could someone tell me how to achieve this.

Many thanks

[oeldere]

Please post the excel file, without confidential information.

[TheCman81]

You can use the below

Please note, if the min value appears more than once then this will return the first instance of it

Headers are A1:D1

=INDEX($A$1:$D$1,MATCH(MIN(A2:D2),A2:D2,0))

[october1702]

Perfect! Thank you

[TheCman81]

Glad to help

[october1702]

Sorry, Can you tell me how to get the =MIN function to ignore nil values?

Many thanks

[TheCman81]

You would have to use an array formula entered with Ctrl Shift Enter

=INDEX($A$1:$D$1,MATCH(MIN(IF(A2:D2<>0,A2:D2)),A2:D2,0))