Hi
Sumproduct array will slow your file down? That reason why Top 10 table not working??
So, I clear all your formula on all sheets.
Top 10 Defects last 12 months sheet
A4 Copy down
B4 Copy down
G4 Copy down.
F4 Copy down
E4 Copy down.
No array formulas on that sheet.
1st & 2nd & 3rd Top Defect sheets
A4 Copy down
B4 Copy down
G7 & F7 &E4 is same formulas as Top 10 Defect sheet.
No Array on all 3 sheets.
You will notice now it a lot faster as Countifs run faster than array Sumproduct or no array Sumproduct and a little faster than sumifs.
See the files
Any problem pm me
Regard
Bookmarks