Hi guys,
I once again need your help. I use a sales database with one order per row (including order date). Another tab holds a lists of dates.
What I want to do is to count the number of orders after each date in the second tab, but ONLY the orders from customers that also placed an order in a certain period running up to that same date.
I attached an example worksheet. Say, I want to know the number of orders AFTER Jan. 3 from those customers that also ordered BEFORE AND INCLUDING Jan. 3. (Customers A, B and C before and including Jan. 3; they placed 2 orders after Jan. 3).
Customer analysis EXAMPLE.xlsx
Thanks in advance,
Stijn
Bookmarks