SORT(FILTER problem with not equal to (<>1)

[ollyhughes1982]

Hi,

I have the following formula:

=SORT(FILTER('parkrun Reader Dump'!B3:B5002,('parkrun Reader Dump'!L3:L5002<>1)*('parkrun Reader Dump'!N3:N5002=1)*('parkrun Reader Dump'!O3:O5002=1)*('parkrun Reader Dump'!P3:P5002=1)*('parkrun Reader Dump'!D3:D5002="United Kingdom")*('parkrun Reader Dump'!L3:L5002="North West England")))

All of the parts work fine, except for the first <>1 filter (in red), which isn’t filtering out the cells with a 1 in column 'parkrun Reader Dump'!L3:L5002. Black Combe parkrun for example, shouldn't be showing, as it has a '1' in 'parkrun Reader Dump'!L3:L5002.

Is there something about the <>1 that is not right? The ones which have =1 as a filter all work fine.

Thanks in advance,

Olly.

 

[ollyhughes1982]

Please ignore this, it was a copy / paste error by myself. I should have been using column 'AF', instead of 'L'.