Results 1 to 5 of 5

Count unique values on a specific date

Threaded View

  1. #3
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    Re: Count unique values on a specific date

    I figured out a way to count the unique customers. But the problem I am now facing is to count the relevant customers. I need to count only the active customers on 31st of each year. Since they all have different periods it makes it difficult. For example: Customer 2 is active on
    22.February 2013 and since it doesīt have an inactive date it is thus active on 31st of December 2013. Customer 3, however, is active 22nd of
    February 2013, but inactive 1st of December 2013, so therefor I canīt count customer 3 in 2013. I have attached a new file.

    Hopefully somebody understands my challenge.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count unique values within a range that meet a specific condition
    By CSS in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-24-2013, 02:00 PM
  2. Count unique values with specific criteria
    By kaz_jones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:56 PM
  3. Replies: 0
    Last Post: 08-09-2010, 02:09 PM
  4. count unique values in columns based on date values
    By cclntn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2010, 06:16 PM
  5. Count unique records for a specific date
    By Mallycat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-22-2010, 07:13 AM

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