Forum Discussion
sbishop785
Apr 03, 2024Copper Contributor
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...
- Apr 03, 2024
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"))
Hecatonchire
Apr 03, 2024Iron 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"))
- sbishop785Apr 03, 2024Copper ContributorThank you both !!!! very much appreciate it