+ Reply to Thread
Results 1 to 2 of 2

How count unique values with date criteria?

  1. #1
    Registered User
    Join Date
    01-24-2022
    Location
    Kettering, OH
    MS-Off Ver
    365
    Posts
    11

    How count unique values with date criteria?

    Hello,

    I've been able to count unique values with criteria via multiple methods, but I can't find a way to make it work with dates. Please see attached.
    Sheet 01-Jan should show a count of 17 unique values.
    These 17 unique values should come from sheet Details_Date-Received column A when the date in column E matches the date in sheet Data's cell E2.
    I've changed the dates to text strings that match, and this formula works:
    =IFERROR(ROWS(UNIQUE(FILTER('Details_Date-Received'!A:A,'Details_Date-Received'!E:E=Data!E2))), 0)

    However, if the cells are populated with dates, the formula results in a CALC error (displayed as 0 due to IFERROR function).
    What am I doing wrong here?

    Please help.
    Thank you.

  2. #2
    Forum Contributor John Vergara's Avatar
    Join Date
    01-17-2022
    Location
    Colombia
    MS-Off Ver
    365
    Posts
    206

    Re: How count unique values with date criteria?

    Hi, @Hites_05!

    You have to take care about dates. These are numbers (natural alignment is at the right of the cell). Recommendation: Not force the align to the left. Just let it free and check if the dates align to the right naturally. Check this results! Blessings!

+ 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] Formula needed to count unique values with multiple criteria within a specific date range
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-29-2021, 10:49 AM
  2. Replies: 2
    Last Post: 07-30-2018, 02:21 PM
  3. [SOLVED] Count unique values for a particular criteria
    By cadineshkumar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2018, 10:36 AM
  4. Find count of unique values with multiple criteria inlcuding date ranges
    By jdooley in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-21-2016, 01:05 PM
  5. [SOLVED] Count Unique Values Based on Earliest Date Criteria
    By Aquamore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2014, 09:12 PM
  6. [SOLVED] Count unique values if 2 other criteria are met
    By sted999 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2014, 11:53 AM
  7. Count unique values with criteria
    By benno87 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-03-2008, 11:13 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