How do I find dups across different columns

  • Thread starter Thread starter Nyrubi
  • Start date Start date
N

Nyrubi

I have a spreadsheet where I need to find dups. For instance col 1 will have
an ID but col5 will have name. There can be several instances of the same ID
but with different names in col5. I want to find all the dups across col1
and col5. I am currently using the following formula:
=IF(COUNTIF($A$1:$A$100,A1)>1,"Dup","Not Dup") How can I enhance this to
include looking for dups across column5? Thank you.
 
Back
Top