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 attache...
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.
- this has worked perfectly. Thank you so much Philip, that was really helpful.
Karen