I have two excel docs; one is a schedule of locations to visit on certain days. The other is an exported report that shows visits made by day. I need to be able to not just compare the report against the schedule, but see which locations were NOT visited on the day they were supposed to (Outlined within the schedule excel doc)
The schedule basically lists locations as rows, the column headers are days of the week, and the values under those are who is supposed to go to said location on that day.
The exported report provides me with locations, who was seen there, and what day it was.
