Forum Discussion
Excel - Filter multiple columns at once
i all
I have an excel spreadsheet. I have added a filter to Column A to choose an option (job title) , but I now want it to automatically filter column B-E on the same job title. I have attached a file which hopefully helps.
In theory, the CEO should be able to open the spreadsheet - filter on Column A to his job title and see all meetings he will attend including ones he is not the lead for.
Thank you in advance for any help.
Karen
One way to do it would be to add an extra column that has an or() formula in it.
Something like this: =OR([@LEAD]=$A$2,[@ATTENDEES]=$A$2,[@ATTENDEES2]=$A$2,[@ATTENDEES3]=$A$2,[@ATTENDEES4]=$A$2)
Where A2 is a drop down of possible attendees. Anything that returns TRUE has that person involved in it. Then you filter that column to show only the meetings you are interested in.
It would mean that you have to click twice.. once to change A2 to a new person, and then again to re-filter the guide column.
I've attached a copy showing what I mean.
