Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am looking at four columns across of data. I can do a simple Min to
find the lowest value of the four columns, but in the cell to the left of the results of the minimum, I would like to identify the column header for the results. Is that possible. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With the headers in A1:D1
and the data in A2:D999 You could put this formula in E2 (and drag down): =index($a$1:$d$1,match(min($a2:$d2),$a2:$d2,0)) You could also replace the min($a2:$d2) with the cell that holds the minimum. === You wanted to see the header for the minimum in each row, right??? wrote: I am looking at four columns across of data. I can do a simple Min to find the lowest value of the four columns, but in the cell to the left of the results of the minimum, I would like to identify the column header for the results. Is that possible. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |