Hello,

I have the below formula and was wondering if there was a way to make it shorter. I am trying to find a way to do an OR statement so I do not have to list each need column with each system separately. Looking for something like


**Formula has been shortened as the formula just repeats for all systems, there are 9 systems.

=FILTER(Roster[Colleague Name],(Roster[Primary Need]="System1")+(Roster[Secondary Need]="System1")+(Roster[Primary Need]="System2")+(Roster[Secondary Need]="System2")+(Roster[Primary Need]="System3")+(Roster[Secondary Need]="System3"))

The columns in the excel file look like this:

Colleague Name | Primary Need | Secondary Need
Test Colleague 1 | System 1
Test Colleague 2 | System 2 | System 3
Test Colleague 3 | System 1 | System 3

Thank you for help with this as I continue to learn more formulas.