+ Reply to Thread
Results 1 to 4 of 4

Counting Unique Values based on a Given Date Range

  1. #1
    Registered User
    Join Date
    11-06-2019
    Location
    Atlanta
    MS-Off Ver
    MS365
    Posts
    2

    Counting Unique Values based on a Given Date Range

    I need help counting unique position numbers within a given date range. The dates are listed in B2 and B3 and will change based on the time period the report will be run. So far, I've tried the following:

    SUMPRODUCT(IF((A:A<=B3)*(A:A>=B2), 1/COUNTIFS(A:A, "<="&B3, A:A, ">="&B2, E:E, E:E), 0))

    But I keep getting zero. How do i count unque postion numbers based on a given date range. I need Counts in B5, B6, B7, and B8. We will add more data each week.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Counting Unique Values based on a Given Date Range

    Hello mbb7344. Welcome to the forum.

    Here are two possibilities. Array enter this formula. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    or just commit this formula with Enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    11-06-2019
    Location
    Atlanta
    MS-Off Ver
    MS365
    Posts
    2

    Re: Counting Unique Values based on a Given Date Range

    Thank you So much FlameRetired! That Worked great for the unique position numbers! How do i do the same count for Unique "text" attatched to the same date range? I want to do counts for "Accepted" "Processed" and "Rejected" based on the date ranges in cells B2 and B3. I appreciate your help in advance!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Counting Unique Values based on a Given Date Range

    Array enter this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    or enter this
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you follow the sense of either of those you should be able to build the remaining two ... "Processed" and "Rejected".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique values based on value with date range
    By papasmurfuo9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2018, 07:24 AM
  2. [SOLVED] Sum selected values in matrix based on date range as well as unique identifier in row
    By smansyd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2014, 07:56 PM
  3. [SOLVED] Counting unique elements based on a date range
    By jumb0 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2012, 03:36 PM
  4. Counting Unique values within a specified date range
    By Bubba88d in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2012, 10:48 AM
  5. Replies: 0
    Last Post: 03-08-2012, 12:18 PM
  6. Replies: 2
    Last Post: 11-15-2011, 07:02 PM
  7. Counting unique records based on date range
    By aspAddict in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2005, 04:05 PM

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