Hi All

Currently I'm trying to understand a complex model (Run with VBA) by recreating using normal excel function and then subsequently intend to re-develop the same Using PowerPivot data model as the existing model takes upto 10 hours to run depending on the amount of data selected. I have almost cracked the code and validated the outcome with my formulas with the exception of the below piece of code which basically performs a Loop calculation of Distinct Countifs on multiple criteria. I'm trying to write a complex countifs formula with array Criteria Range along with array Criterias in order to achieve the outcome but in vain.

I was wondering if anybody could guide me in achieving the aforesaid formula. Below is part of the VBA code which does what is explained above.

Thanks


Please Login or Register  to view this content.