Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX from different columns
Having trouble with this.
I am trying to find the MAX value from (C3:C6,F3:F5) but can't get it to work. Essentially, it's a list split over two columns from which I'd like the Max highlighted using conditional formatting. Thanks -- Traa Dy Liooar Jock |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX from different columns
=MAX(C3:C7,F3:F5)
-- Gary''s Student - gsnu200755 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX from different columns
Hi Jock,
=MAX(C3:C6,F3:F5) works fine for me What problem do you have? -- Kind regards, Niek Otten Microsoft MVP - Excel "Jock" wrote in message ... | Having trouble with this. | I am trying to find the MAX value from (C3:C6,F3:F5) but can't get it to work. | Essentially, it's a list split over two columns from which I'd like the Max | highlighted using conditional formatting. | | Thanks | -- | Traa Dy Liooar | | Jock |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX from different columns
=MAX(C3:C6,F3:F5)
use formula is, select first F3:F5, hold down ctrl and select C3:C6, that will make C3 the active cell then do the conditional formatting =C3=MAX($C$3:$C$6,$F$3:$F$5) -- Regards, Peo Sjoblom "Jock" wrote in message ... Having trouble with this. I am trying to find the MAX value from (C3:C6,F3:F5) but can't get it to work. Essentially, it's a list split over two columns from which I'd like the Max highlighted using conditional formatting. Thanks -- Traa Dy Liooar Jock |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX from different columns
Nope, still can't get it to work.
Both your solution and Gary''s Students results in ALL seven possibles being formatted (in red), whereas Peo's idea has only F3 highlighted even though this cell doesn't contain the highest value. Ok had a play now It works by placing: =C3=MAX($C$3:$C$6,$F$3:$F$5) for the firsf column, and =F3=MAX($C$3:$C$6,$F$3:$F$5) for the other. I've tested it and it works (for some reason!) -- Traa Dy Liooar Jock "Gary''s Student" wrote: =MAX(C3:C7,F3:F5) -- Gary''s Student - gsnu200755 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |