Results 1 to 16 of 16

Count unique dates with registration, month and year criteria

Threaded View

  1. 04-28-2024, 09:50 AM #1
    ShihTzu
    ShihTzu is offline
    Registered User
    Join Date
    04-27-2024
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    12

    Red face Count unique dates with registration, month and year criteria

    Hi,

    I need help with the formula to achieve count of unique dates with registration, year and month as criteria.

    Sample data as below.

    1.PNG

    Result required as follows.

    2.PNG

    Attaching the Excel file for referrence.

    Thank you for the great help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to count number of unique values ONLY in the month/year they first appear
    By LangePier in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 02-04-2024, 09:08 AM
  2. Count days per month per year between 2 dates
    By bojef in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-16-2023, 03:22 AM
  3. Count Unique Records based on multiple criteria by month and year.
    By hecgroups in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2022, 03:58 AM
  4. [SOLVED] Extract count of dates with Month and Year criteria
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2017, 06:03 AM
  5. [SOLVED] Countif criteria for variable month/year but ONLY if 3rd value is latest, unique in-month
    By jpeate in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-08-2014, 05:06 PM
  6. counting unique values across several criteria and date (month/year)
    By joannelittell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 06:19 AM
  7. unique occurances per multiple criteria (including month/year)
    By joannelittell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-09-2013, 04:54 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1