Forum Discussion
Solved
Filter multiple columns
I am working on a list of reporters and the topics they cover. Since most reporters cover multiple topics, I have three columns for primary, secondary, and tertiary topics of interest. I'm trying to ...
I've attached a solution that uses FILTER, a new function. This will only work if you have the latest version of Excel
The function below is in cell B13 of the attached. In cell E10 you can select (from a drop down list) any of the several categories and see the reporters who cover the topic.
=FILTER(B3:E8,(C3:C8=E10)+(D3:D8=E10)+(E3:E8=E10))
I've attached a solution that uses FILTER, a new function. This will only work if you have the latest version of Excel
The function below is in cell B13 of the attached. In cell E10 you can select (from a drop down list) any of the several categories and see the reporters who cover the topic.
=FILTER(B3:E8,(C3:C8=E10)+(D3:D8=E10)+(E3:E8=E10))
This was really helpful thank you so much!