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 |
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 |