DKY Wrote:
That works, thanks
One other question, how do I format this
MIN(C2:F2)
into Dollars, same format as when I hit the $ button.
Let me explain this a little more, I wanted to add
MIN(C2:F2)
to this
INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0))
so that it looks like this
MIN(C2:F2)&" "&(INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0)))
but I want to format this part
MIN(C2:F2)
into Dollars and not the rest of it. Is that possible?
--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread:
http://www.excelforum.com/showthread...hreadid=524315