Find largest value and return placement

[Molly]

Assuming you want the Name of the Company - A, B or C -
with max sales:

In first column, assuming it is column A with Company
names in Cells B1, C1 and D1 and Company Sales in Rows 2
through whatever - try:

A2 =INDEX($B$1:$D$1,1,MATCH(MAX(B22),B22,0))
A3 =INDEX($B$1:$D$1,1,MATCH(MAX(B33),B33,0))
A4 =INDEX($B$1:$D$1,1,MATCH(MAX(B44),B44,0))
A5 =INDEX($B$1:$D$1,1,MATCH(MAX(B55),B55,0))

etc.

Does this do you?

 

[PJD]

It do me good! Thanks a ton.

-----Original Message-----
Assuming you want the Name of the Company - A, B or C -
with max sales:

In first column, assuming it is column A with Company
names in Cells B1, C1 and D1 and Company Sales in Rows 2
through whatever - try:

A2 =INDEX($B$1:$D$1,1,MATCH(MAX(B22),B22,0))
A3 =INDEX($B$1:$D$1,1,MATCH(MAX(B33),B33,0))
A4 =INDEX($B$1:$D$1,1,MATCH(MAX(B44),B44,0))
A5 =INDEX($B$1:$D$1,1,MATCH(MAX(B55),B55,0))

etc.

Does this do you?
.