Combine two SORT(FILTER( formulas

[ollyhughes1982]

Hi,

I currently have a formula where I am filtering on 4 criteria, from a single worksheet (parkrun Reader Dump). The formula is as follows:

=SORT(FILTER('parkrun Reader Dump'!B3:B5003,('parkrun Reader Dump'!N3:N5003=1)*('parkrun Reader Dump'!O3:O5003=1)*('parkrun Reader Dump'!P3:P5003=1)*('parkrun Reader Dump'!D3:D5003="United Kingdom")))

I now want to add in one extra criterion, but from another worksheet (Miscellaneous Data - P & C p). The formula for this is as follows:

=SORT(FILTER('Miscellaneous Data - P & C p'!B3:B5003,('Miscellaneous Data - P & C p'!D3:D5003="United Kingdom")*('Miscellaneous Data - P & C p'!AM3:AM5003=1)))

Is there a way I can now combine the two filters, so that it filters on all 5 criteria together?

Thanks in advance!

Olly.

 

[ollyhughes1982]

I've now manage to do this a different. way. Thanks.

 

[Peter_SSs]

Glad to hear you got the solution.

If you would like to post your solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.