Results 1 to 4 of 4

counting unique customers in a list by a specific date range

Threaded View

perducci counting unique customers in... 03-07-2012, 10:45 PM
perducci Re: counting unique customers... 03-07-2012, 11:13 PM
perducci Re: counting unique customers... 03-08-2012, 01:05 PM
perducci Re: counting unique customers... 03-08-2012, 01:07 PM
  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Salt Lake City, UT
    MS-Off Ver
    Excel 2010
    Posts
    78

    counting unique customers in a list by a specific date range

    [DIFFICULT] I have a list of customers that have made orders on several different dates. I want to count the number of unique customers for a specific date range.

    the equation I use below doesn't work and I'm not sure why.

    =SUM(IF(AND(FREQUENCY(MATCH(B2:B13,B2:B13,0),MATCH(B2:B13,B2:B13,0))>0,E2:E13>=K3,E2:E13<=K4),1,0))

    B2:B13 refers to the customers
    E2:E13 are the dates of the orders
    K3 and K4 are the date range

    See the attached spreadsheet, thanks
    Attached Files Attached Files
    Last edited by perducci; 03-08-2012 at 01:06 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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