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.
Bookmarks