De-Duplication

J

JulieD

Hi Dom

Chip Pearson has some great macros & ideas on working with duplicates on his
website -
check the index at
http://www.cpearson.com/excel/topic.htm

Regards
JulieD

Dom said:
Hi,
I have column A & B with 8 digit reference numbers listed in each column.
Click to expand...
However column A contains more reference numbers than column B. Column B
also contains the same reference numbers as column A. How can I match each
row with the same 8 digit reference number to allow me to easily view those
reference numbers that are not duplicated?
 
D

Dom

Hi,
I have column A & B with 8 digit reference numbers listed in each column. However column A contains more reference numbers than column B. Column B also contains the same reference numbers as column A. How can I match each row with the same 8 digit reference number to allow me to easily view those reference numbers that are not duplicated?

Many thanks
Dom
 
A

Andy B

Dom

First of all, try here:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Chip has lots of info on duplicates that should be able to help you.

Andy.

Dom said:
Hi,
I have column A & B with 8 digit reference numbers listed in each column.
Click to expand...
However column A contains more reference numbers than column B. Column B
also contains the same reference numbers as column A. How can I match each
row with the same 8 digit reference number to allow me to easily view those
reference numbers that are not duplicated?
 
Top