Forum Discussion
Filter (not sort) multiple columns at one time?
I am building a spreadsheet to track approx 30 people to see who is scheduled to work on which calendar day. In column A are the names (rows 2-61) and columns B-AL are the dates in question. Not everyone is scheduled to work on the same dates.
I'm would like to be able to filter multiple columns (without altering the list order as there is other information specific to an individual in the row below their name) for the value Scheduled so I have one return showing each time Scheduled is the cell value.
Example:
Row 2, Scheduled is entered in columns F, H, N, O, P, V, Z, AF, AJ
Row 3, Scheduled is entered in columns E, F, N, P, Z, Ad, AF, AG
Row 3, Scheduled is entered in columns B, C, D, E, L, P, R, W, Z, AD, AE, AF
And so on. How can I filter to display each time the value Scheduled appears so I know who is working when without filtering it column by column and copying those results to a different page one by one to create a composite? I cannot change the list order as a 'sort' would do.
2 Replies
- PeterBartholomew1Silver Contributor
- Harun24HRBronze Contributor
Did you try FILTER()/SORT() function? You may attach a sample file.