Need only duplicate Values, how to do this using VBA

[prasath]

Hi,

I have two sets of data in my file. And i have to find out the duplicate values between these fields (only duplicate filed)

For Example

Table 1

A
B
D

Table 2

B
D
F

Ideal Output

A
F

it could be really fine, if we did this through VBA. Pl. suggest..

Thanks in advance

Prasath RH

 

[prasath]

Hi,

Could anyone help me on this request..

Thanks

 

[aravindhan_31]

Can you send a sample workbook to aravindhan_31@yahoo.com

 

[prasath]

Can you send a sample workbook to aravindhan_31@yahoo.com

Hi,

Thanks for your reply. I have send a worksheet to the mail id..

Regards,
Prasath RH

 

[Weaver]

Am I right in thinking your output should consist of the datasets that are not duplicated?

 

[prasath]

Am I right in thinking your output should consist of the datasets that are not duplicated?

Data 1

A
B
C
D
E
F
G



Data 2

B
C
D



Ideal Output

B
C
D




"B, C, D" is available both "Data 1" and Data 2". So is required in "Ideal Output" space

 

[Weaver]

Okay, but that seems different from your original request.