Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions |