Forum Discussion
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 Engagement Minutes'!F:F>=A2)*('MM User Engagement Minutes'!F:F<=B2))
to ignore return rows with "EMC Staff" in column E:E of the sheet it pulls from, named 'MM User Engagement Minutes'.
Unsure if I need to do this in 2 steps? to use the above FILTER, and then filter that list once more to ignore return rows with "EMC Staff"?
Please help!
Thanks!!!
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"))
3 Replies
- HecatonchireIron Contributor
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"))
- sbishop785Copper ContributorThank you both !!!! very much appreciate it
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"), "")