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
Bookmarks