Forum Discussion

MelanieOgle's avatar
MelanieOgle
Copper Contributor
Jan 29, 2025

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.

Resources