De-Duplication

[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

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?

 

[Guest]

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

 

[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.

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?