Compare 2 columns with 2 columns and find duplicates

mattdeligero

New Member
Joined
Sep 15, 2014
Messages
1
Hi,

I have 4 columns and i need a macro where column A be compared to C, and column B to D. When value A matches with any value in column C, and value B with any value in column D, I need value A and value B to be listed on columns E and F in the same order.

A1: Dog
B1: Puppy
C1: Bear
D1: Cub
E1: Dog
F1: Puppy
A2: Duck
B2: Duckling
C2: Dog
D2: Puppy
E2: Cat
F2: Kitten
A3: Cat
B3: Kitten
C3: Kangaroo
D3: Joey
E3
F3
A4:
B4:
C4: Chicken
D4: Chick
E4
F4
A5:
B5:
C5: Cat
D5: Kitten
E5
F5

<tbody>
</tbody>

I hope i was able to describe it clearly. If you have clarifications, please let me know.

Thank you for your help.

- Matt
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,600
Messages
5,832,651
Members
430,151
Latest member
Kacbear

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top