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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,108,634
Messages
5,523,996
Members
409,555
Latest member
TIPSAREA

This Week's Hot Topics

Top