See the attached spreadsheet:
Please provide guidance in how I would do the following, and thank you for your time and efforts. It is greatly appreciated
Sheet1 should be a VLOOKUP to COUNT the # of Incidents (Column F of the Log tab) for each Customer (A, B, and C of the Log spreadsheet) and display the value in Column B of Sheet1 (expected value highlighted in blue). An Incident is when Column F (of the Log tab) = "Incident"
Sheet1 should be a VLOOKUP to COUNT the # of Incidents in 3 months (Column F of the Log tab) for each Customer (A, B, and C of the Log spreadsheet) and display the value in Column G of Sheet1. The only difference here is that it should count only those incidents in the last 3 months (expected value highlighted in yellow). An Incident is when Column F (of the Log tab) = "Incident" and the Incident Date (of the Log tab) is Column D
Sheet1 should be a VLOOKUP to COUNT the # of Late Deliveries (Column C of the Log tab) for each Customer (A, B, and C of the Log tab) and display the value in Column C of Sheet1. A late shipment is when Column C = "Late Shipment" or "Delayed Shipment". The expected value is highlighted in orange.
Bookmarks