in excel if you ask it to find the minimum value in a row. how do you get it
to quote the heading of the colum instead of the number in the box

Let's say you numbers are in A1:M1 and the minimum value is in E1
This =MATCH(MIN(A1:M1),A1:M1,FALSE) will tell you the min is in column 5
(not E but 5)
This =ADDRESS(1,MATCH(MIN(A1:M1),A1:M1,FALSE)) will return $E$5
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dan" wrote in message
...
in excel if you ask it to find the minimum value in a row. how do you get
it
to quote the heading of the colum instead of the number in the box

You could use a VLOOKUP function combined with a MIN function, something
like:

=VLOOKUP(MIN(E5:E11),E5:F11,2,FALSE)

Hope that helps

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=528080