VBA to Find 4 types of Duplicates with multiple criteria

Hi Guys,

Im sorry that i forgot to mention, my data has around 1 million rows. So any help that can make my code works faster?

Bump... No 1 can help?

PL see the attached file with array formula in Sheet1(2) and macro with its result in Sheet1.
Try this on a copy of your original file.
I feel time required will be far less than what at present macro(you are having) is taking.

Hi kvsrinivasamurthy,

Thank you very much for the reply and the formula, it is indeed faster than my macro.
For now i just need to know if there is "Macro" that can do the job faster than the formula because as i said i have around 1 million rows in my database, so i need the fastest way. If there is then perhaps some1 will be kind enough to share a way to making the code.

Any help will be appreciated. Thanks in advance.

Pl try this macro. It took 6 mins for 150000 rows.

Hi kvsrinivasamurthy,

Thanks so much for the code, i tried your code and its a lot faster :D, only 1 problem, when i tried it with 400.000 rows it shows error, is there a limit for the code to works?

Hi kvsrinivasamurthy,

I have found the problem already, apparently i have some cells with equal "=" signs and that makes excel read it as an error, now the code works perfectly.

Thanks for the help,really appreciate it.

Best Regards,
Jul

welcome Jul stev.