Forum Discussion
Solved
HELP please - Filter function to ignore specific text in column
Hi there Microsoft Community!!! I have a minor set back with my spreadsheet. I can't seem to figure out how to modify this function: =FILTER('MM User Engagement Minutes'!A:F,('MM User Engagemen...
Hi
=FILTER('MM User Engagement Minutes'!A:F,('MM User Engagement Minutes'!F:F>=A2)*('MM User Engagement Minutes'!F:F<=B2)*('MM User Engagement Minutes'!C:C<>"EMC Staff"))
Try this:
=FILTER('MM User Engagement Minutes'!A:F, ('MM User Engagement Minutes'!F:F>=A2)*('MM User Engagement Minutes'!F:F<=B2)*('MM User Engagement Minutes'!E:E<>"EMC Staff"), "")