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