column number of the answer to MIN
 

How do I grab the column number to this function
MIN(C2:F2)

Actually, what I'm looking to do is display the header of whatever the
answer to the above function is. All the headers are in row 1. So in
essence, if the min is in column D then it will display the data in D1.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

=INDEX(C1:F1,1,MATCH(MIN(C2:F2),C2:F2;0))

HTH
--
AP

"DKY" a écrit dans le
message de ...

How do I grab the column number to this function
MIN(C2:F2)

Actually, what I'm looking to do is display the header of whatever the
answer to the above function is. All the headers are in row 1. So in
essence, if the min is in column D then it will display the data in D1.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

=INDEX(C1:F1,,MATCH(MIN(C2:F2),C2:F2,0))

--
Kind regards,

Niek Otten

"DKY" wrote in message ...

How do I grab the column number to this function
MIN(C2:F2)

Actually, what I'm looking to do is display the header of whatever the
answer to the above function is. All the headers are in row 1. So in
essence, if the min is in column D then it will display the data in D1.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

I guess I should have mentioned that I would like to copy this down to
other rows, This only works on row 2 but not on row 3 etc....

One other quick question. How do I format this
MIN(C2:F2)
into Dollars, same format as when I hit the $ button.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

I just noticed, it's because it changes it to this
=(INDEX(C2:F2,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)
instead of this
=(INDEX(C1:F1,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)

How do I keep that first C1:F1 the same if I'm copying it down?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

use C$1:F$1

--
Kind regards,

Niek Otten

"DKY" wrote in message ...

I just noticed, it's because it changes it to this
=(INDEX(C2:F2,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)
instead of this
=(INDEX(C1:F1,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)

How do I keep that first C1:F1 the same if I'm copying it down?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

That works, thanks

One other question, how do I format this
MIN(C2:F2)
into Dollars, same format as when I hit the $ button.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

column number of the answer to MIN
 

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

column number of the answer to MIN
 

=TEXT(MIN(C2:F2),"FormatString")&" "&(INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0)))

Replace FormatString with your format string. You can find it by formatting a cell as $ and then choose FormatCellsNumber tab,
Custom and copy the format string from the Type box.
It has to be in quotes in your formula.

--
Kind regards,

Niek Otten



"DKY" wrote in message ...

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