Sheet Calculation slow

[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

 

[Daniel.M]

Hi Nika,

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

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.