alternative to FOR EACH to apply COUNTIF formula to each cell to check for DUPLICATE

Please Login or Register  to view this content.

Something like that. Is there an alternative method to countif on a range of cells to check for duplicate because it seems really slow even with the adjustment of manual calculation and false screenupdate.

thanks Vikas.

I guess I could try those 2 methods but actually I'm more into looking for an alternate method to paste the countif formula to each cell like pasting all 30000 cells at one shot and running the formulas instead of looping each cell and pasting 1 by 1.

thanks Vikas.

I guess I could try those 2 methods but actually I'm more into looking for an alternate method to paste the countif formula to each cell like pasting all 30000 cells at one shot and running the formulas instead of looping each cell and pasting 1 by 1.

I do not think any loop for 30,000 rows will be slow. You have not posted the entire code to see which lines are making the code to slow down, better would be if you could attach a sample.