superdongo
New Member
Hello,
i'm trying to determine the number of occurrences on duplicate records by using =COUNTIF(A$1:$A1,A1) formula. It works perfectly. The problem is, the calculation is very slow. (i'm running on intel core dual processor both over 3.33ghz and 4GB RAM)
i dont know if it's my pc or not, but is there any work around for this?
Thank you all!
i'm trying to determine the number of occurrences on duplicate records by using =COUNTIF(A$1:$A1,A1) formula. It works perfectly. The problem is, the calculation is very slow. (i'm running on intel core dual processor both over 3.33ghz and 4GB RAM)
i dont know if it's my pc or not, but is there any work around for this?
Thank you all!
