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
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Eliminate non-matching cells 8
Eliminating non-matching cells 3
Move cells 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Find largest value in column with 2 criteria 1
Counting unique values in multiple columns 4

Top