in excel how do you quote a differnt cell

dan · 03-30-2006, 09:25 AM

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

**kosciosco** · 03-30-2006, 09:37 AM

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

Bernard Liengme · 03-30-2006, 09:45 AM

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" <dan@discussions.microsoft.com> wrote in message
news:A9FC815E-1184-4924-9B80-88EFDDA8865C@microsoft.com...
> 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