Formula that returns column header after comparison

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
 
R

Ragdyer

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.
 
D

Drewcifur

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
 
R

Ragdyer

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.
 
Top