if there are not alot of columns, I would concatenate the columns, separating each with a special symbol, in order to avoid crossovers
e.g.
=A1&"^^"&B1&"^^"&C1&"^^"&D1
copied down
then you can use Countif to find if there are dupes:
=COUNTIF($E$1:$E1,$E1)>1
copied down (where E1 contains first concatenation formula)
TRUE means there are duplicates.
Bookmarks