Array example to remove duplicates entry
Closed
samkhu
TrowaD
- Posts
- 2
- Registration date
- Wednesday October 17, 2012
- Status
- Member
- Last seen
- October 31, 2012
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- Array example to remove duplicates entry
- How to remove registry entries of uninstalled software - Guide
- Excel - A macro to sort dates and remove duplicates - How-To - Excel
- MacOS: Find and remove duplicates - How-To - MacOS
- Remove duplicated data ✓ - Forum - Excel
- Count number of trips when duplicate entries ✓ - Forum - Office Software
1 reply
TrowaD
Nov 1, 2012 at 11:16 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Nov 1, 2012 at 11:16 AM
Hi Samkhu,
This works for excel 03.
Select a cell in your table, goto top menu > Data > Filter > Advanced Filter.
Check your tables range and select "Unique records only".
Select copy to different location and select your location.
Now you can remove your original list and replace it by your filtered list.
I believe later versions of Excel has the ability to remove duplicates with a single click on the right button.
Hope this helps,
Trowa
This works for excel 03.
Select a cell in your table, goto top menu > Data > Filter > Advanced Filter.
Check your tables range and select "Unique records only".
Select copy to different location and select your location.
Now you can remove your original list and replace it by your filtered list.
I believe later versions of Excel has the ability to remove duplicates with a single click on the right button.
Hope this helps,
Trowa