Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value column name look up
Is it possible to lookup the minimum value in a set of numbers in a row and
then also list the column name for where the minimum answer value came from? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value column name look up
In A1:F1 I have the numbers 90, 80, 50, 60, 85, 75
The formula =MATCH(MIN(A1:F1),A1:F1,0) returns the value 3 since the minimum value resides in the third cell of the array. This formula returns the value C - the column with the min value: =INDEX({"A","B","C","D","E","F"},MATCH(MIN(A1:F1), A1:F1,0)) while this returns $C$1 =ADDRESS(1,MATCH(MIN(A1:F1),A1:F1,0)) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "shifty" wrote in message ... Is it possible to lookup the minimum value in a set of numbers in a row and then also list the column name for where the minimum answer value came from? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
minimum value column name look up
Assuming your set of numbers is in row 2 and your column names are in row 1,
this should return the minimum: =MIN(2:2) and this the column heading: =INDEX(1:1,MATCH(MIN(2:2),2:2,0)) If you want to put the first of these in the same row as your numbers, you will need to specify the range more precisely, for example: =MIN(A2:H2) with the formula in column I or later. "shifty" wrote in message ... Is it possible to lookup the minimum value in a set of numbers in a row and then also list the column name for where the minimum answer value came from? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to move to minimum value in column of data | Excel Discussion (Misc queries) | |||
Find minimum value in column. | Excel Worksheet Functions | |||
How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
Header of column which has minimum in row? | Excel Discussion (Misc queries) | |||
Minimum qualifiers to Find (VBA) the actual last used Row, Column | Excel Discussion (Misc queries) |