how do i compare two columns and remove duplicates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to repeat a specific function almost daily. i have two coulums of 10
digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
want to search a for the sets of numbers in b. when found i need to elimnate
them from both colums.

i am a beginner in excel. i believe a macro can do this but have no idea
how to create one.
 
aljernon805 said:
i need to repeat a specific function almost daily. i have two coulums of 10
digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
want to search a for the sets of numbers in b. when found i need to elimnate
them from both colums.

i am a beginner in excel. i believe a macro can do this but have no idea
how to create one.
Click to expand...
Take a look at this excellent site provided by Pearson Software

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

gls858
 
Back
Top