hangs/freezes/doesn’t respond.

[countryfan_nt]

Hello friends, hope all is well!

My Excel hangs/freezes/doesn’t respond, when I apply the below formula on more than 100,000 rows.

How to apply the formula without the above issues?
Can it be done via powerpivot? What dax formula can I use?

=COUNTIFS($D$5:D5,D5,$E$5:E5,E5,$F$5:F5,F5)

Thank you very much in advance!

 

[ranman256]

when you apply formulas to 100k recs, you will slow down.
Instead, run a pivot table to get the count. You get the same result with no lag.