|
Posted to microsoft.public.excel.programming
|
|
|
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!
|