Hi Karl,

as per usual, there was something I missed. You were right, it doesn't
return the required maximum.

Try this one, also an array formula...

=MAX(--(A1:A124=7)*B1:B124)

I'm fairly confident this one works (unless I've missed something
again, which is sometimes the case:-))

Ken Johnson