I have a formula as under in Colm J starting from Row 2 & down to Row 55000.

=IF(SUMPRODUCT(--($A2=$A$2:A2),--($C2=$C$2:C2),--($E2=$E$2:E2))1,0,1)

I am using the formula to determine unique supplier count based on
region/Supplier/Commodity.

This formula slows down the workbook & my attempts to do manual calculation
(shift+F9) is not responsive. The Calculation Cells : information is not
progressing beyond 5% and finallt Excel says, it is not responding.

Help Please

Can anybody help by devising a macro