Formula that returns column header after comparison

  • Thread starter Thread starter Drewcifur
  • Start date Start date
D

Drewcifur

I have numeric data in 4 different columns. Each column has a different
label. I want to compare the numbers in each column on a row by row basis
and have the column label of the lowest value inserted in a different column
at the end of the row.

Anyone have suggestions on the best way to accomplish that?

Thanks in advance!

Cheers
Drew
 
Say your data is in A1 to D100, with labels in Row1.
In say E2, try this formula:

=INDEX($A$1:$D$1,MATCH(MIN(A2:D2),A2:D2,0))

Copy down as needed.
 
I'm with you, but I'm dumb, so here's further specifics:

The four data columns are F3 to F(x) and J3 to J(x) and N3 to N(x) and R3 to
R(x)

Corresponding column labels that I want returned are in C1 and G1 and K1 and
O1

Returned column labels will appear in U3 to U(x)

I'm playing with the strings, but like I said - I'm dumb!

TIA
Drew
 
This may or may not work, depending on what data is in the columns between
the ones referenced in the formula:

=INDEX($C$1:$O$1,MATCH(MIN(F3:R3),F3:R3,0))

Enter in U3, and copy down as needed.
 
Back
Top