Find min and equal value

[huy_le]

Hi,

Is there a formula to say all the values are equal, like Min and Max formula to find highest and lowest values. For example I have 15 columns, I want to say find the lowest value and return the header of that value, or if all these values are equal, start from the beginning.

A B C D F E
2 2 3 4 1

So, the formula would help me find and return F in column E. If all these values are equal, then at column E I would see A as the value and so on.

Note: If we can do this vertically, that would be awesome too, otherwise, it's ok.

Thanks.

[zbor]

try

Please Login or Register  to view this content.

[Pete_UK]

Put this under E (cell F2 ?):

=INDEX($A$1:$E$1,MATCH(MIN(A2:E2),$A2:$E2,0))

Hope this helps.

Pete

[huy_le]

That works! Thanks guy!

[huy_le]

Btw, just curious, can we achieve the same result vertically? Like:

A B
1 1
2 1
3 2
4 2
5 0
6

So basically row 6 now is acting like column E before. It would return 5 as value.

Thanks.

[zbor]

Yust reverse rows and columns:

Please Login or Register  to view this content.

[huy_le]

That works, thanks again zbor