Friday, 27 July 2012

How to Find Duplicates by Comparing Multiple Columns in Excel

Excel Match Function to Find Duplicates by Comparing one Column with another Column
By using IF and MATCH functions combination, you can find out the duplicates in a column by comparing it with another column.
Syntax:
=IF(ISNA(MATCH(LookupValue, LookupArray, MatchType)), False, True)
Here:
Ø  ISNA refers to IS Not Available means if the LookupValue is not available in the LookupArray, then the if condition returns the False statement first else returns the True statement.
For More reference about IF, MATCH Functions, Please search in Search Box available at the top of this Blog.
Remarks:
If you don’t use the ISNA in the formula then IF condition returns #N/A for False Statement

Example: 




Note:
If you have any ambiguity/if you want any another formula/method Please comment about it.

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts