ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Header (https://www.excelbanter.com/excel-discussion-misc-queries/188154-excel-header.html)

[email protected]

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

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


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com