Why you don't use your formula for column 5?

"Nyrubi" wrote:

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.