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?
|