View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kyle.macdonald[_2_] kyle.macdonald[_2_] is offline
external usenet poster
 
Posts: 1
Default 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!