Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SEeing if a number in one column is in another column | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
look up number in column | Excel Worksheet Functions | |||
How do I sort a column a unique number? | Excel Worksheet Functions |