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

[hecgroups]

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.

[AliGW]

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.