FINDING DUPLICATES - CROSS REEFERENCE 2 COLOUMNS TO FIND UNIQUE EN
 

I HAVE A LIST CONSISTING OF 2 COLUMNS. I MUST FIND THE DUPLICATE IN ONE LIST
AND HIGHLIGHT THEM.

EXAMPLE:

LIST 1.

COLUMN 1 COLUMN 2

A12A 12384
A129D 1987
A139D 1987
A12A 12843

THESE WOULD BE UNIQUE!

A12A 12345
A12A 12345

tHIS WOULD BE A DUPLICATE.


WOULD BE APPRECIATIVE OF YOUR HELP!

FINDING DUPLICATES - CROSS REEFERENCE 2 COLOUMNS TO FIND UNIQUE EN
 

Hi,
see CPeardon web

http://www.cpearson.com/excel/Duplicates.aspx
or
http://www.cpearson.com/excel/ListFunctions.aspx

"kyle.macdonald" wrote:

I HAVE A LIST CONSISTING OF 2 COLUMNS. I MUST FIND THE DUPLICATE IN ONE LIST
AND HIGHLIGHT THEM.

EXAMPLE:

LIST 1.

COLUMN 1 COLUMN 2

A12A 12384
A129D 1987
A139D 1987
A12A 12843

THESE WOULD BE UNIQUE!

A12A 12345
A12A 12345

tHIS WOULD BE A DUPLICATE.


WOULD BE APPRECIATIVE OF YOUR HELP!