find duplicates

[sheshadrinurani]

Hi,

I have some names in (worksheet) 1 column A and values in corressponding column B, similarly another worksheet 2 has names in column A and values in column B. Some of the names in worksheet 1 and worksheet 2 are similar so how can I mark either one as duplicate?

 

[mrMozambique]

You can use the CountIf function. For example, if your potential duplicates are in Sheet1 Col A and Sheet2 Col A, you can find which of Sheet1's entries are also in Col A of Sheet2 with this formula in Sheet1 cell C1. Copy the formula down to the end of your range. Any cells > 0 have duplicates in Sheet2.

=COUNTIF(Sheet2!A:A,A1)

 

[sheshadrinurani]

Thanks it works, however i had seen a 'duplicate' remark coming up in the C1 field, don't know maybe it was an add-in, any idea?