VBA to replace Countifs

Hello,

I have a spreadsheet that has 11 columns and almost 850,000 row. Each day should have 48 readings, but some have more, due to duplicates, others have less.
When I use Countifs, it is very slow and constantly crashes. I was wondering if anyone had any suggestions on VBA code I could use?
I have created a small sample sheet. It has less columns and rows, but should give you an idea of what I'm looking for.

If this runs fine, replace Sheet.Add with Sheets("YourSheeName")

Please Login or Register  to view this content.

Thank you, this works perfectly

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.