How to get summary table with unique count and sum value using VBA

Dear Forum experts,

It is a continuity of my previous thread and link has been given below. One of the expert helped me a lot and as much as he can, where as I did not pen down my requirement properly. But now, i have properly listed my requirements and model excel sheet has been attached for your kind reference and looking for VBA code / Macro.

https://www.excelforum.com/excel-pro...-countifs.html

I have a set of individual hospital data, which provides services by month wise and I want to extract only new hospital which newly joined in this month and provides services. We can easily identify the "New" hospital in the column J and which has been indicated as "1". In a month, those new hospital might have been reported 2 times. We want to get unique hospital details based on Hospital Unique ID in the column "E". All the requirement has been clearly given in the attached excel sheet.

Requirement : 1- Unique count value based on multiple criteria (State/Province wise and Month wise) as well as particular column cell has "1" value.

Requirement : 2- Unique sum (cumulative) value based on multiple criteria (State/Province wise and Month wise) as well as particular column cell has "1" value.

Thanks for your support.

I think my code is working fine, but the execution time is not short (a few seconds).

Please Login or Register  to view this content.

Please try

Please Login or Register  to view this content.