I have a some ID numbers in column C than run for approx 75k rows.
In another column i have the following formulae:
I have calculation set to manual, but it is very slow when i do calculate. Is there a more efficient way of counting the instances of each ID?
Many thanks!
Chris
In another column i have the following formulae:
=COUNTIF($C$3:$C$75174,C3)
I have calculation set to manual, but it is very slow when i do calculate. Is there a more efficient way of counting the instances of each ID?
Many thanks!
Chris