economist2010
New Member
- Joined
- Jan 31, 2012
- Messages
- 48
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.
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.