Non-matching cells

G

GARY

COL A has 800,000 cells and COL B has 790,000 cells.

Here's an portion of my spreadsheet:

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

In Excel 2007, how do I find the cells in COL B whose first 11
characters do NOT match the first 11 characters in the cells in COL A?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non-matching cells 1
Non -matching cells 1
Count Non-Blank Cells in Column If a Reference Criteria Met. 5
Delete cells 0
Delete cells 10
Matching dates to cells 3
Compare the value of one cell to 2 different cells 4
Matching cells 1

Top