Results 1 to 2 of 2

Count Unique Records based on multiple criteria by month and year.

Threaded View

  1. 05-19-2022, 03:28 AM #1
    hecgroups
    hecgroups is offline
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    909

    Count Unique Records based on multiple criteria by month and year.

    Looking for an help to minimized my hours job into few minutes.

    Explanation:

    I have a master list which contain some number in column A. The same number are available in batch worksheets in column D.

    So, I need to check the per month code from batch sheet in column D is available in MasterList sheet column A for the months available in results sheet cell AA.

    For example:
    757 for Private
    First check the unique code numbers for the month of January 2021 and unique code need to match with masterlist and count the number for private only.

    I hope I language is explainable.
    Attached Files Attached Files
    Last edited by AliGW; 05-19-2022 at 03:28 AM. Reason: Irrelevant section of title removed.
    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] formula to count unique values based on multiple criteria
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-27-2021, 09:19 PM
  2. count number of records per month based on criteria
    By nd2828 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-17-2018, 01:12 PM
  3. Formula to count unique value in a sheet based on multiple criteria
    By dhasa in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-05-2018, 12:00 PM
  4. [SOLVED] count the number of unique text records with multiple criteria
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2016, 04:30 PM
  5. Count unique records relative to multiple criteria
    By MStyles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2013, 09:56 AM
  6. 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
  7. Formula to count Unique text based on multiple criteria
    By OAMPS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2012, 10:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1