Results 1 to 10 of 10

Restrict counting orders after date x ONLY to customers that also ordered before date x

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2007
    Posts
    11

    Restrict counting orders after date x ONLY to customers that also ordered before date x

    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
    Last edited by Stijn@hccnet.nl; 12-21-2012 at 10:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1