G
Guest
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
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