Hello everyone,
I have a workbook that I am trying to organize by Operator, Valid Complaints BEFORE 6/30/20 and Valid Complaints AFTER 7/1/20. The raw data will be on the Sheet titled COMPLAINTS -20 and I need to filter through that data and have it sorted in the AGENTS spreadsheet according to the various column headings shown on that sheet. I have already added the formula for column D and E on the AGENTS spreadsheet. I'm just not sure what formulas to use in order to achieve the results I have in A2, B2, and C2. I am using Office 365.
Thanks in advance for your help.
Bookmarks