I manage a small business and have been asked to summarize a calendar we have in Excel. Basically we clean buildings every quarter - 1x a year is a full cleaning, 2x are just outside, and 1x sweep/vacuum but not full cleaning --> full and sweep can't be right after each other. We schedule out about 2 years but things change regularly. Each person has like 20-25 buildings. Attached is a short example of two years.
F = full, O = outside, S = sweep
I'm not an Excel pro by any means but took some courses in college years ago and remember a little. Is there a way to summarize these by month and employee?
I have a new sheet where I made a drop down for Employee and Month but I can't seem to find a way to summarize them nicely.
I've tried a bunch of things but without success - pivot tables, combinations of giant if statements using index/match functions, arrays
Basically if Cleaner = A and Month = January and any cell within those parameters = F, then list the names of those locations.
Can anyone help here? Or is it too difficult for a more novice user like me to do in Excel? Any help would be appreciated - thanks.
Bookmarks