From: Javed on
On May 6, 2:39 am, gcotterl <gcott...(a)> wrote:
> COL A has 800,000 cells
> COL B has 750,000 cells
> How do I find the cells in COL B that do NOT match the cells in COL A?

It is better to use conditional format:
In the Cf dialog choose "formula is" and insert the formula


and choose any pattern that will help you highlight the non matching

What do you mean by "find" I thought highlight it may be also doing
other things if possible specify.

Or if you want further analysis you can use pivot tables also.But the
process is a bit deep.If you give me exact address of cells ,sheet
name,filename i can give the code.