Eliminating cells with non-matching characters

G

gary

Col A has 3,444 cells
Col B contains 94,422 cells

How can I eliminate the cells in COL B if their 7 left-most characters are NOT equal to the 7 left-most characters in the cells in COL A?
 
I

isabelle

hi Gary,

enter this formula in cell C1
it is an array formula, it must be confirmed with ctrl + shift + enter
and then fill down

=IF(ISERROR(MATCH(LEFT(B3,7),LEFT(A:A,7),0)),"Supp.","OK")

isabelle


Le 2013-01-19 22:41, gary a écrit :
 

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

Eliminating cells 3
Dealing with the error: unable to filter on excel hc home school 0
Eliminate non-matching cells 10
Macro for comparing columns and highlighting matching/differences 13
Counting unique values in multiple columns 4
Move cells 1
Eliminating non-matching cells 3
Lookup formula help 4

Top