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 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"))

     

    sbishop785 

3 Replies

  • Hecatonchire's avatar
    Hecatonchire
    Iron 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"))

     

    sbishop785 

  • sbishop785 

    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"), "")

Resources