Previous Topic Next Topic

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
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 - Nov 1, 2012 at 11:16 AM
Hi there,

I have three column for lookup and i used combination of all there as a primary key to look into master sheet.

want to remove the duplicate entry which is comes after addition of all three columns.

example column A(ID)+B(Name)+C(Citi) ....100SamUK if let say there is 10 rows and and we have duplicate rows in that 10 records.

How to remove that through array?
Any example will be higly appreciated.

1 reply

Answer 1 / 1
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
 512
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
0