Non-matching cells

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

gcotterl

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?
 
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?
Click to expand...


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

=ISNA(VLOOKUP(Cell1OfColB,ColARange,1,0))

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

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.
 
Back
Top