in excel how do you quote a differnt cell

D

dan

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
 
K

kosciosco

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

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

Hope that helps

Simo
 
B

Bernard Liengme

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?
 
Top