Thread: Conditional MAX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zsolt Szabó Zsolt Szabó is offline
external usenet poster
 
Posts: 29
Default Conditional MAX

Hello
In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5
=IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number
in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"")
without everytime fixing my formula in C5?
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt