compare List A and list B delete the number that occurred more th.

[compare list A and list AB]

Dear All
I have2 list, A and B, I need to compare list A and list B and delete the
number that occurred more than one time, and fine how many numbers accurred
more than one time. any help

 

[Bernie Deitrick]

You need to better define your problem: delete numbers that occur more than
once in list A OR list B, or that appear in both list A AND list B, or just
delete the numbers from list A that already appear in list B but leave them
in list B, etc. etc. etc....

HTH,
Bernie
MS Excel MVP

"compare list A and list AB" <compare list A and list
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Bernie Deitrick]

Dear comparelistAandlistAB,

Say that list A is in A1:A100, and list B is in D1100

In Cell B1, enter the formula

=IF(ISERROR(MATCH(A1,$D$1:$D$100,FALSE)),"Keep","Delete")

Copy down B2:B100, then copy and paste as values. Then sort A1:B100 based
on column B, and delete all the values with "Delete" next to them.

HTH,
Bernie
MS Excel MVP

"compare list A and list AB"