I have 2 columns of data, for example…


COLUMN 1 COLUMN 2

EN-2 3K7*
EN-5 4K7
EN-6 5K7
EN-2 3K7*
EN-3 3K7
EN-3 3K7
EN-3 5K7
EN-4 4K7
EN-5 3K7
EN-2 4K7

As indicated above (rows EN-2 3K7), I would like to know of a formula that would highlight and count duplicate entries where the data is the same across both columns.

Thanks