Results 1 to 14 of 14

Finding unique values for a date range

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    marlow, uk
    MS-Off Ver
    Office for Mac 2011
    Posts
    17

    Finding unique values for a date range

    I need to find unique users from a particular location that appear between two dates.

    I can find all entries (in column P of the My Marketing sheet) within the date range (defined by E53 and F53) and within a particular country with:
    =IFERROR(COUNTIFS('My Marketing'!P:P,">="&E53,'My Marketing'!P:P,"<"&F53,'My Marketing'!E:E,"Australia"),0)

    And I can find all unique entries in the column D with:
    =SUMPRODUCT(('My Marketing'!D:D<>"")/COUNTIF('My Marketing'!D:D,'My Marketing'!D:D&""))

    But no amount of experimenting or googling has lead me to the solution that allows me to join these together.

    How do I adjust the first function to limit the results to unique ones?

    Thanks for you help.
    Gav
    Last edited by designergav; 05-01-2015 at 07:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding Unique Values in a Range
    By phelbin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-02-2015, 07:30 PM
  2. Finding Unique Values in Named Range
    By jonboy6257 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-02-2014, 04:58 PM
  3. Unique Values by month in date range
    By kerrynyc in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-25-2013, 04:53 PM
  4. Count Unique Values within date range
    By onthepitch in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-20-2012, 02:29 PM
  5. Finding unique values from a filtered range
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 11:00 AM

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