I have a spreadsheet containing a year's worth of shipping info, including the shipment date.
What I would like to do is, for a given customer, get all shipments that were shipped within 5 days of each other.
So if ABC Vendor had a shipment 1/1/10, 1/2/10, 2/1/10, 2/19/10, 3/1/10, 3/4/10 and 3/5/10 I'd like to see only the shipments on 1/1, 1/2, 3/1, 3/4 and 3/5. It's a big file so going through it manually is out of the question. Any ideas?
Bookmarks