pineapple61
New Member
- Joined
- Jan 31, 2023
- Messages
- 7
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
- MacOS
Hi everyone,
I have three columns A, B, and C and I want to filter the rows that pertain to one of the drop-down list selections that I created, what would be the formula for this?
For example, I have listed the first, second and third job preferences of a number of people. I would like to see the names of the people that want to be a "doctor", no matter if it's their first, second or third preference. I have named my table "Work" to make it easier to filter and used the formula: =FILTER(Work, Work[First Job]=G1) - See image.
Now that I have filtered this and by using the selection list that I have, I can see the name of those that have Doctor as their first preference but I don't know how to add everyone else that has "Doctor" in their second and third job preference. What would be the formula for this?
I tried to do this next but it did not work for me, =FILTER(Work, Work[First Job]=G1)*(Work[Second Job]=G1)
I have three columns A, B, and C and I want to filter the rows that pertain to one of the drop-down list selections that I created, what would be the formula for this?
For example, I have listed the first, second and third job preferences of a number of people. I would like to see the names of the people that want to be a "doctor", no matter if it's their first, second or third preference. I have named my table "Work" to make it easier to filter and used the formula: =FILTER(Work, Work[First Job]=G1) - See image.
Now that I have filtered this and by using the selection list that I have, I can see the name of those that have Doctor as their first preference but I don't know how to add everyone else that has "Doctor" in their second and third job preference. What would be the formula for this?
I tried to do this next but it did not work for me, =FILTER(Work, Work[First Job]=G1)*(Work[Second Job]=G1)