JamesBowdidge
New Member
- Joined
- Nov 8, 2018
- Messages
- 46
=Countif($a$2:$a$150000,a2)
So when copied down in B and pressing F9 takes litterally 10-15 mins to calculate..
I have used this before and it didnt take this long?
any suggestions as to why? or an alternative to achieve the same result?
thanks
J
So when copied down in B and pressing F9 takes litterally 10-15 mins to calculate..
I have used this before and it didnt take this long?
any suggestions as to why? or an alternative to achieve the same result?
thanks
J