ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   look across row - pick highest value - take aplha code of column (https://www.excelbanter.com/excel-discussion-misc-queries/91627-look-across-row-pick-highest-value-take-aplha-code-column.html)

Little pete

look across row - pick highest value - take aplha code of column
 
I have a large work sheet that is set out like the following;

NEW
COLUMN
A B C D Value
Court 1 0 20 0 80 D
Court 2 30 10 60 0 C
Court 3 90 0 10 0 A
Court 4 0 100 0 0 B

I want to add a new column (Value) to each row which looks across the row to
find the highest value and then takes the Alpha code at the top of that
column.

Any help on this would be great.

Cheers Peter

Ron Coderre

look across row - pick highest value - take aplha code of column
 
Try something like this:

With your data list in A1:E5

F2: =INDEX($A$1:$E$1,1,MATCH(MAX(B2:E2),A2:E2,0))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Little pete" wrote:

I have a large work sheet that is set out like the following;

NEW
COLUMN
A B C D Value
Court 1 0 20 0 80 D
Court 2 30 10 60 0 C
Court 3 90 0 10 0 A
Court 4 0 100 0 0 B

I want to add a new column (Value) to each row which looks across the row to
find the highest value and then takes the Alpha code at the top of that
column.

Any help on this would be great.

Cheers Peter


Dave Peterson

look across row - pick highest value - take aplha code of column
 
=index($a$1:$d$1,match(max($a2:$d2),$a2:$d2,0))

And drag down.

(adjust the columns to match)

Little pete wrote:

I have a large work sheet that is set out like the following;

NEW
COLUMN
A B C D Value
Court 1 0 20 0 80 D
Court 2 30 10 60 0 C
Court 3 90 0 10 0 A
Court 4 0 100 0 0 B

I want to add a new column (Value) to each row which looks across the row to
find the highest value and then takes the Alpha code at the top of that
column.

Any help on this would be great.

Cheers Peter


--

Dave Peterson

Little pete

look across row - pick highest value - take aplha code of colu
 
excellent!!

Cheers

"Dave Peterson" wrote:

=index($a$1:$d$1,match(max($a2:$d2),$a2:$d2,0))

And drag down.

(adjust the columns to match)

Little pete wrote:

I have a large work sheet that is set out like the following;

NEW
COLUMN
A B C D Value
Court 1 0 20 0 80 D
Court 2 30 10 60 0 C
Court 3 90 0 10 0 A
Court 4 0 100 0 0 B

I want to add a new column (Value) to each row which looks across the row to
find the highest value and then takes the Alpha code at the top of that
column.

Any help on this would be great.

Cheers Peter


--

Dave Peterson



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

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