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?

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

"AllenR2" wrote in message
...
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?

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

"AllenR2" wrote in
message
...
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?


.

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi
simply record a macro while invoking the advanced filter

--
Regards
Frank Kabel
Frankfurt, Germany

"marina madeleine" schrieb im
Newsbeitrag ...
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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!