Count same numbers from another data

[jalolbek85]

Dear Excel Experts,

I have a huge data that I want to count the same numbers from other data (each rows).

And I have recently got the formula through this forum and it's counting perfectly but taking almost 3-6 hours when I apply the formula in the entire columns then copy & past as special.

So would really appreciate if somebody could provide me either VBA, Macro or any other formula which counts the data maximum within 5-20 mins like other normal formulas

I have attached the workbook for easy reference.

Thanks in advance