Non-matching cells

[GARY]

COL A has 800,000 cells
COL B has 750,000 cells

Here's an example of my spreadsheet:

A B
008101966-1 008101966-1
008101968-3 008101968-3
008101969-4 008101979-3
008101970-4 008101968-3
008101979-3 008101979-3
008101981-4 008101981-4
008102023-2 008102023-2
008102025-4 008102025-4
008102028-7 008102023-2
008102030-8 008102025-4
008102313-4 008102319-0
008102314-5 008102368-4
008102319-0 008102369-5
008102368-4 008102402-1
008102369-5 008102404-3
008102402-1 008102417-5
008102404-3 008102418-6
008102417-5 008102437-3
008102418-6 008102438-4
008102437-3 008102443-8
008102438-4 008102455-9
008102439-5 008102464-7
008102443-8 008102465-8
008102455-9 008102466-9
008102464-7 008102535-8
008102465-8 008102548-0
008102466-9 008102561-1
008102482-3 008102562-2
008102485-6
008102535-8
008102548-0


How do I can search all of the cells in both columns and find the
cells in COL B that do NOT match the cells in COL A?

 

[Herbert Seidenberg]

Excel 2007 Advanced Filter
With optional macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_04_10.xlsm
Pdf preview (2 pgs):
http://www.mediafire.com/file/mjj2mtyqj0n/05_04_10.pdf