Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
You can use =INDEX(B1:G2,1,match(min(B2:G2),B2:G2,0)). Please note that if there are multiple minimum values, then this will work only for the first minimum value. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "CeciliaPDX" wrote in message ... Hello-- I have a min value that I pulled from a row that contains several columns. I am trying to identify what the column label for that min. value is: So in the example below, I'm pulling the min value of 1 and would like to be able to return D since that corresponds to the MIN value. Thanks!!! A B C D E F 16 3 7 2 29 18 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching two values | Excel Worksheet Functions | |||
Matching Values | Excel Worksheet Functions | |||
Matching 2nd & 3rd values | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
matching two values | Excel Discussion (Misc queries) |