Sheet Calculation slow

N

nika

Frank
Thanks for your reply.

You are right in what you say but I have improved the calc speed a bi
more with this formula

=COUNTDIFF(IF(($F$2:$F$600=AM$1)*($F$2:$F$600<>""),$D$2:$D$600))-1

it is actually an excel add in formula which is much shorter and doe
offer more speed but like you said not that much more

thanks for looking into it
appreciated
nik
 
D

Daniel.M

Hi Nika,
=COUNTDIFF(IF(($F$2:$F$600=AM$1)*($F$2:$F$600<>""),$D$2:$D$600))-1
Click to expand...

Optimising a bit:

=COUNTDIFF(IF(($F$2:$F$600=AM$1)*(AM$1<>""),$D$2:$D$600))-1

Are you allowed to sort your data in columns F and D? (As this could improve the
calcs speed significantly) Let me know.

Regards,

Daniel M.
 
Top