Forum Discussion

sbishop785's avatar
sbishop785
Copper Contributor
Apr 03, 2024
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...
  • Hecatonchire's avatar
    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"))

     

    sbishop785 

Resources