Deleting Duplicate Rows
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? |
Deleting Duplicate Rows
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? |
Deleting Duplicate Rows
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? . |
Deleting Duplicate Rows
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! |
Deleting Duplicate Rows
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! |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com