Deleting Duplicate Rows

[AllenR2]

I've been looking through the posts for something to do
this but haven't found anything. I need to delete all rows
in a worksheet that have the same values in ALL columns. I
have 5 columns on this sheet so if the values in all five
of these columns are the same as they are in another row I
need to delete that entire row.

Could someone give some input or point me to the proper
post?

 

[Tom Ogilvy]

select all five columns (just the data area and header) and do
Data=>Filter=>Advanced filter

check the unique checkbox
select copy to a new location (on the same sheet) and designate that
location

then click OK.

 

[AllenR2]

Thank you, Tom

Worked great!

-----Original Message-----
select all five columns (just the data area and header) and do
Data=>Filter=>Advanced filter

check the unique checkbox
select copy to a new location (on the same sheet) and designate that
location

then click OK.

--
Regards,
Tom Ogilvy




.

 

[marina madeleine]

I happened to see this thread on deleting duplicate rows from a while
back (for a worksheet where the rows have the same values in all
columns) and have tried out the advanced filter for unique rows.

While I am able to do the advanced filter manually, is there any code
you could suggest that would do the same which would delete all the
duplicate rows in the excel worksheet?

Thanks.

Marina Madeleine

 

[Frank Kabel]

Hi
simply record a macro while invoking the advanced filter