Delete ALL duplicate rows in an excel sheet

Hello,

I've seen to run into a problem. I am trying to delete all of the duplicate rows within an excel sheet. However, when using a filter to display only unique values or removing all duplicate values functions from excel it still leaves the original row. How would I go about deleting all the rows that contain duplicate data leaving only the unique rows. Any help is appreciated! Thanks in advance!

Originally Posted by ragavan.sridar1

did you tried using "Remove duplicates" function?

yes. no luck.

Originally Posted by ragavan.sridar1

can u post a sample workbook?

Sure. For example I would like to remove all instances of Red, 1, A.

Thanks!

help please?

Originally Posted by mike7952

Maybe this will work for you

Please Login or Register  to view this content.

this works for the sample workbook! my workbook that I need to use it on goes to column G and has 40,000 rows. Any way you can show me how to adjust the code to account for this amount of rows? thanks!!!