Macro Help for a BIG Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You might find this better.

In F2 add

=A2&C2&E2

In G2, add

=--(COUNTIF($F$2:F2,F2)=1)

copy F2. G2 down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top