On my "Aged List" workbook I have a formula in column G "=IF(SUMPRODUCT(--(Table7[Policy Number]=$A2),--(Table7[Work Type]=$B2)),"Yes","No")"
Where I basically need to match combinations of Column A & Column B on "Source" tab to the "ITS" tab on column A & B)
The formula works great. But i have an issue. The calculation can take up to 20-30 minutes at times. And when I open it back up after closing it locks all my sheets up for twice as long. Is there a more efficent way to run this across 40K plus lines?