Get rid of duplicates in excel using VBA

[MrRriche]

what if the duplicate is written in a different format like for example, i have JOHN, DOE and DOES JOHN, and JOHN, DOES SR.,,,all are the same people how would i highlight them all.

[utubecoyote]

Very good. I have an application for this right away. Thank you.

[csibond]

this is a very good tutorial..hope you would still make a lot of tutorials :) i would like to learn a lot about MS excel visual basic..thanks a lot..

[csibond]

would this still function right even if the duplicates are not found on the next rows immediately following the original values? like the original value of row 2 has its duplicate value in row 10..

[nagileon]

No, you must add a For loop checking all rows below the second row.