Find the duplicates

[Sheepkin_Coat]

Hi

I have a spreadsheet with peoples names on it FirstName in column A1 to A1773 LastName in column b1 to b1773 and have other first names in D1 to D1773 and last names in E1 to E1773, What i want is to find if the same name appears in A,B & D,E.

So for an example
A B D E
Jim Beam Jim Beam

And i want a list of the names that are are in A,B and not D,E

Can anybody help me with this

Sorry if this has been asked before.

[LokeshKumar]

Please upload the sample workbook.....

[Sheepkin_Coat]

Here is the test spreadsheet

[:) Sixthsense :)]

In F2 Cell


=IF(COUNTIFS(A:A,D2,B:B,E2),"Found in Col-A & B","Not Found")


Drag it down...

[LokeshKumar]

Hi,
I try to understand and here goes your attachment....boox1.xlsx
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.