Remove duplicated data
Solved/Closed
SherlynPeh
SherlynPeh
- Posts
- 8
- Registration date
- Tuesday August 5, 2014
- Status
- Member
- Last seen
- August 14, 2014
SherlynPeh
- Posts
- 8
- Registration date
- Tuesday August 5, 2014
- Status
- Member
- Last seen
- August 14, 2014
Related:
- Remove duplicated data
- Compare two worksheets and Remove duplicated data from one ✓ - Forum - Excel
- Excel - A macro to sort dates and remove duplicates - How-To - Excel
- MacOS: Find and remove duplicates - How-To - MacOS
- Excel duplicate data from one sheet to another - Guide
- Remove duplicates in itunes windows 10 - Guide
2 replies
TrowaD
Aug 7, 2014 at 10:44 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Aug 7, 2014 at 10:44 AM
Hi SherlynPeh,
The Advanced Filter (under the Data tab) has an option to keep unique records.
For more details check this recent thread:
https://ccm.net/forum/affich-760797-removing-duplicate-data#p762925
Best regards,
Trowa
The Advanced Filter (under the Data tab) has an option to keep unique records.
For more details check this recent thread:
https://ccm.net/forum/affich-760797-removing-duplicate-data#p762925
Best regards,
Trowa
SherlynPeh
Aug 8, 2014 at 02:14 AM
- Posts
- 8
- Registration date
- Tuesday August 5, 2014
- Status
- Member
- Last seen
- August 14, 2014
Aug 8, 2014 at 02:14 AM
Hi Trowa,
I'd tried the above method but keep error. I don't quite understand why I cant copy to another worksheet. Thank you once again for your help :)
TrowaD
Aug 11, 2014 at 11:43 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Aug 11, 2014 at 11:43 AM
Hi Sherlyn,
My opinion is that Microsoft forgot to update the process because it can be done by Macro.
When recording the process you will get:
Range("H1:H4").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1:A4"), Unique:=True
Here range H1:H4 is your source data (which you want to filter) and range A1:A4 is the destination range. Now place your sheet reference in front of the destination range, like:
Range("H1:H4").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("Sheet2").Range("A1:A4"), Unique:=True
Now adjust the source and destination range and the sheet reference to match yours.
If this is not a 1 time action and you want it more dynamic, then let us know.
Best regards,
Trowa
My opinion is that Microsoft forgot to update the process because it can be done by Macro.
When recording the process you will get:
Range("H1:H4").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1:A4"), Unique:=True
Here range H1:H4 is your source data (which you want to filter) and range A1:A4 is the destination range. Now place your sheet reference in front of the destination range, like:
Range("H1:H4").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("Sheet2").Range("A1:A4"), Unique:=True
Now adjust the source and destination range and the sheet reference to match yours.
If this is not a 1 time action and you want it more dynamic, then let us know.
Best regards,
Trowa
SherlynPeh
Aug 11, 2014 at 10:35 PM
- Posts
- 8
- Registration date
- Tuesday August 5, 2014
- Status
- Member
- Last seen
- August 14, 2014
Aug 11, 2014 at 10:35 PM
Hi Trowa,
Do you mean I have to create the vba codes for macro instead of recording it?
Is there any other ways to achieve the same result without using macro? Thank you so much for the prompt reply :)
Hope you have a nice day.
Do you mean I have to create the vba codes for macro instead of recording it?
Is there any other ways to achieve the same result without using macro? Thank you so much for the prompt reply :)
Hope you have a nice day.
SherlynPeh
Aug 11, 2014 at 11:05 PM
- Posts
- 8
- Registration date
- Tuesday August 5, 2014
- Status
- Member
- Last seen
- August 14, 2014
Aug 11, 2014 at 11:05 PM
Oh! I managed to find out the reason why I keep encounter error during advance filtering. Thanks for the guide along the way :)
