Hi Team,
Good morning.
I am hoping someone could assist me with my problem.
I have a summary of all customers (Data tab) which contains a checklist of the documents they submitted. If there is no check on any of the DOCUMENT COLUMN, then it means that customer is DEFICIENT with that document.
What I need is to find those customers and create a summary of their deficiency (Please see sample file for your reference).
Is it possible using PIVOT or Formula? or there is really no choice but to use VBA?
Appreciate your response.
Thank you
Bookmarks