Comparing Two Columns in Excel Sheet

Hi,

  I need formula for comparing two columns. For Eg,

Column A, Column B has datas, for Eg, In Column A has Names and Column B has E-mail Ids,

If Both Name and Email Id repeates in the next row Column C should show its Duplicate Entry.

Kindly Advice,

Ram | ram@gmail.com | Unique

Kumar | kumar@yahoo.com | Unique

Ram | ram@gmail.com | Duplicate

like this.

I am waiting for your help.

Steve

The first one is surely a duplicate also? (of the last one)

There are many ways of identifying duplicates. I would point you to this site which lays out many options.

http://www.cpearson.com/Excel/Duplicates.aspx

Hi Nick,

    Thanks, But I need to Check both the cell at a time.

Steve

Sorry, I'm not with you? Was there not a solution on the website I gave you? Remember to look for duplicates across multiple columns you will need to concatenate the data, possibly in a helper column, so for example, in column D enter

=A1&B1

and test against that. e.g your data would look like this in column D

Ramram@gmail.com
Kumarkumar@yahoo.com
Ramram@gmail.com

Steve

This is just a demonstration of what Nick has said above...

As Nick says you need to concatenate the information first (at least this is the easiest way). You can then use COUNTIF to test the uniqueness.

Your example indicates that you do no wish to flag the 1st occurrence as being a duplicate, we can achieve this by making half the range in the COUNTIF dynamic, i.e. we only test against values above. Column C could be hidden if required. (this is the 6th example on the website Nick referenced).

Code:

Result

Hope this helps,

Regards,

Teppic

Ya thanks for all of yours help. yes atlast as Nick referred, I did it.

A1 | B1 | =(A1&B1) | Unique

Thanks for your idea.

Its working for me. :)