Array example to remove duplicates entry
Closed
samkhu
Posts
2
Registration date
Wednesday October 17, 2012
Status
Member
Last seen
October 31, 2012
-
Oct 31, 2012 at 10:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 1, 2012 at 11:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 1, 2012 at 11:16 AM
Related:
- Array example to remove duplicates entry
- Vba check if value is in array - Guide
- How to undo remove link on instagram bio - Instagram Forum
- Remove wga - Download - Cleaning and optimization
- Nokia.mobi/entry/van/main/c7-00 ✓ - Nokia Forum
- How to remove business account on tiktok ✓ - TikTok Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 1, 2012 at 11:16 AM
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