Formula that returns column header after comparison

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Drewcifur - 27 Aug 2007 01:19 GMT

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

Reply to this Message

Ragdyer - 27 Aug 2007 01:52 GMT

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.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> 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
[quoted text clipped - 7 lines]
> Cheers
> Drew

Reply to this Message

Drewcifur - 27 Aug 2007 03:26 GMT

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

> Say your data is in A1 to D100, with labels in Row1.
> In say E2, try this formula:
[quoted text clipped - 15 lines]
>> Cheers
>> Drew

Reply to this Message

Ragdyer - 28 Aug 2007 01:47 GMT

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.

Signature

> I'm with you, but I'm dumb, so here's further specifics:
>
[quoted text clipped - 30 lines]
>>> Cheers
>>> Drew

Reply to this Message