How do I find dups across different columns

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Function??? 2
Dups and Conditional Formating 2
Identifying Dups in different ranges 1
MATCH UP DATA IN COLUMNS 2
merge two worksheets with different columns and data 7
data validation across multiple columns 1
Sumproduct across mutliple columns 3
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) 2

Top