Hi,

i have 2 columns and i'm trying to calculate the conditonal maximum from
column one.

These are the columns :

47 7
44 7
71 7
58 7
214 4
22 4
54 7
1 7
45 7
21 7


and i try to find a formula that gives the maximum in column one, where
column 2 has value 7

in this case this would be 58

Marc