Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.

This is a 7 page document perfect for students to work on individually. I would say it is perfect for year 7 and 8 but could be used for older KS2 children also. The document then briefly describes ...