hellooperator
New Member
- Joined
- Nov 30, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
- MacOS
I have a spreadsheet with instructors who are teaching classes. Within each class row there is a column with an instructor name, and a column with the date & time of the class they are teaching.
What I want to be able to do is input a date & time into a search to show me all the instructors in the spreadsheet which do NOT have that date/time in a row, so that I can find available instructors quickly (currently I am filtering by each individual instructor to see if that date/time is taken for them or not).
Is this feasible and if so what is the easiest way for me to do this?
Thanks in advance for any help!
What I want to be able to do is input a date & time into a search to show me all the instructors in the spreadsheet which do NOT have that date/time in a row, so that I can find available instructors quickly (currently I am filtering by each individual instructor to see if that date/time is taken for them or not).
Is this feasible and if so what is the easiest way for me to do this?
Thanks in advance for any help!