Tricky - worlds slowest formula

[thorpyuk]

Hiya,

Does anyone have any ways that i might speed this formula up?


{=SUM(IF(FREQUENCY(MATCH(Matchback!$A$2:$A$6473,Matchback!$A$2:$A$6473,0),MATCH(Matchback!$A$2:$A$6473,Matchback!$A$2:$A$6473,0))>0,IF(Matchback!$C$2:$C$6473=Analysis!$B18,1)))-G18}



Essentially, what it's doing is looking at a load of customer baskets matching a code in cell B18, and then using FREQUENCY to get a unique customer count.

Takes about 5-10 seconds per formula to evaluate, and there's probably over 100 of these swines!!!

Thanks

 

[GlennUK]

Wouldn't you be better off using a PivotTable? Like:

http://www.contextures.com/xlpivot07.html#Unique