Keep one of duplicates

[economist2010]

Hi all,

I have two sheet as follows:

1- Sheet 1: includes the mobile numbers of all customers.

2- Sheet 2: includes some of the mobile numbers in sheet 1 who win the prize.

Note: sheet 1 includes +1M records.

Which code that I can use to remove all number who didn't win and keep only one of the duplicates for the numbers that won (as they will be in sheet 1 and in sheet 2). I need to only keep this in sheet .

Appreciate your kind support.

 

[economist2010]

Please let me know if my query is not cleared enough

 

[alansidman]

Post some sample data using XL2BB. In this manner, we can provide you with a workable solution for your exact issue. If unfamiliar with XL2BB look at my signature. Your samples should not contain more than 15-20 records.

 

[economist2010]

Post some sample data using XL2BB. In this manner, we can provide you with a workable solution for your exact issue. If unfamiliar with XL2BB look at my signature. Your samples should not contain more than 15-20 records.

 

[economist2010]

Post some sample data using XL2BB. In this manner, we can provide you with a workable solution for your exact issue. If unfamiliar with XL2BB look at my signature. Your samples should not contain more than 15-20 records.

I would like to keep the winners in sheet 3 who only are mentioned in sheet 1 or sheet 2. And at the same time remove other mobile numbers in sheet 3 for those who are not mentioned in sheet 1 or sheet 2.
Hope that now it is more clear.

 

[economist2010]

Remove winners in sheet 2 from sheet 1 and keep the other mobile numbers (that are not mentioned in sheet 2) in sheet 1 as they are.

 

[alansidman]

I am not going to rebuild your spreadsheet to solve your issue. Please re-upload with XL2BB as pictures cannot be manipulated and you are asking for help. Make it easy for us to help you and not make additional work.

 

[economist2010]

I am not going to rebuild your spreadsheet to solve your issue. Please re-upload with XL2BB as pictures cannot be manipulated and you are asking for help. Make it easy for us to help you and not make additional work.

Excel- keep duplicate & remove others.xlsx
	A
1	11567890
2	11567891
3	11567892
4	11567893
5	11567894
6	11567895
7	11567896
8	11567897
9	11567898
10	11567899
11	11567900
12	11567901
13	11567902
14	11567903
15	11567904
16	11567905
17	11567906
Sheet1

Hi Alan. The point is that this is my first time to use this feature that's why I was worried that I would not be able to use it properly.


Please confirm if I used it properly and that it is my query is more clearer to you now.

 

[economist2010]

Remove winners in sheet 2 from sheet 1 and keep the other mobile numbers (that are not mentioned in sheet 2) in sheet 1 as they are.

exclude winners from 1M.xlsx
	A
1	10010101010
2	10010101011
3	10010101012
4	10010101013
5	10010101014
6	10010101015
7	10010101016
8	10010101017
9	10010101018
10	10010101019
11	10010101020
12	10010101021
13	10010101022
14	10010101023
15	10010101024
16	10010101025
17	10010101026
18	10010101027
19	10010101028
20	10010101029
1M record

 

[alansidman]

I see no relationship between the two files. There are no duplicates between them. Suggest you show us what the result would look like using these two files so we better understand what you are looking for.