Hi there,

i have a formula that current looks like this:
={MAX(IF((AreaCode=$T$3)*(SampleType=$C$1)*(ParamCode=$B7)*OR(LocationCode<>{"GW37","GW33","GW41","GW31"})>0,Unxtab_RAWData!$R$2:$R$34999))}

the idea being is searches through the data which has ~35000 rows, and provides the max for a column when in accordance with the criteria. It worked fine before, however the bit I have just added in is the "LocationCode" selection highlighted in bold, as i need to remove some points (the ones with location IDs GW37,GW33,GW41,GW31). However, this bit isn't working and the values for these locations are still being summarised (or maxed) in by data.

does anyone have an idea of where i'm going wrong?

thanks