Try

=IF(LOOKUP(10^10,C:C)=MAX(C60:C5000),LOOKUP(10^10, C:C),"")

--
__________________________________
HTH

Bob

"Zsolt Szabó" wrote in message
...
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