Conditional MAX

[Zsolt Szabó]

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?

 

[Bob Phillips]

Try

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

 

[Zsolt Szabó]

Bob,
Thanks your help. C5 = HH5 ( The last entered number is the highest from the
last 5 entered numbers). If I type into cell C65 5, C66 1, C67 2, C68 3, C69
3.5, C70 4, than from the last 5 enterd numbers the last one is the highest
and your formula result is "". I like to see as a result the 4.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt

Try

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

 

[Bob Phillips]

I thought you wanted to check all the numbers, are you saying that you only
want to check the last 5?

--
__________________________________
HTH

Bob

Bob,
Thanks your help. C5 = HH5 ( The last entered number is the highest from
the
last 5 entered numbers). If I type into cell C65 5, C66 1, C67 2, C68 3,
C69
3.5, C70 4, than from the last 5 enterd numbers the last one is the
highest
and your formula result is "". I like to see as a result the 4.

 

[Zsolt Szabó]

Yes, I like to check only the last 5 numbers and I would like to see the
result in C5 IF the last entered number is the highest compare to the last 5
entered numbers.