Forum

Filter Function usi...
 
Notifications
Clear all

[Solved] Filter Function using Drop down excluding one category.

5 Posts
2 Users
0 Reactions
197 Views
 Bee
(@bee)
Posts: 7
Active Member
Topic starter
 

Hi,

I have an Excel file that marks site-based personnel as Part-time, Full-time Time and left the site. I created another sheet with a dropdown menu and a filter function where I can search for people by project. My problem is how do I exclude those who have 'Left the Site' and show only those who are working full time/part timer on the site, and off-site/office support.

TIA for the help.

Screenshot 2025 05 14 144351

 

 
Posted : 14/05/2025 11:49 pm
Topic Tags
Riny van Eekelen
(@riny)
Posts: 1246
Member Moderator
 

@bee

Not entirely sure on how you built your schedule as your data doesn't seem to be in a structured table. I would recommend you do that.

Regarding the FILTER function you can 'combine' multiple conditions with the * sign and the + sign.

* works like AND, + like OR.

In your case you would need something like this:

=FILTER( Table, (ProjectRange = D5) * (StatusRange <> "Left the Site") )

 
Posted : 15/05/2025 1:36 am
 Bee
(@bee)
Posts: 7
Active Member
Topic starter
 

Thank you for the response. The structured table is located in another sheet, as shown in the attachment. The initial attachment above is where I'm trying to apply the filter. I want the 'Search by Project' sheet to display only those who are actively working on the site (i.e., Part-time, Full-time, Office Support, PRD/Off-site Support) and not include those who are marked as 'Left the site'

Screenshot 2025 05 16 084304

 

 
Posted : 16/05/2025 5:48 pm
Riny van Eekelen
(@riny)
Posts: 1246
Member Moderator
 

@bee 

Perhaps best to demonstrate in a working model. Does the attached file contain the solution you need? If not, what would be the end result you're after in that example?

 

 
Posted : 16/05/2025 6:39 pm
 Bee
(@bee)
Posts: 7
Active Member
Topic starter
 

@riny This works! Thanks, as I didn't know about the function "<>". Again Many thanks! 😊

 
Posted : 16/05/2025 6:53 pm
Share: