View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default 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