Hello everybody,

I have a problem with this statement =MAX(IF(($C$8:$C$13=$D2);$D$8:$D$13)) that return the VALUE! error.

My need is to search for the MAX value only of some Rows (rows that has Owner="Mary" and not Owner="Tony" or "Jack").

Any idea ?

Thanks,
ilao