Filter for 225 or 233 numbers

  • Thread starter Thread starter hoganc
  • Start date Start date
H

hoganc

Hi all,

me again with what i think should be pretty a basic but its not! to m
at least

i get given a list of codes and I need to find all the no.s tha
contain 233 or 225 in them,

what i am asking is without mining through the data myself and we ar
talking a good 20,000 no.s here which looks like this

0152552362
0152253362

the no.s i am looking for all contain 225 or 233 and have four no.
which follow that also change.

so counting from the right i am searching for the fifth sixth an
seventh digits to be 225 or 233

any ideas anyone
???

thanks
in advance
:eek
 
Hi

one option is to add in another column and use the following formula to
determine whether or not the data meets the criteria (if it does TRUE is
returned otherwise FALSE) and then use the autofilter to filter those
records

=OR(MID(A1,4,3)="233",MID(A1,4,3)="225")
where A1 is the cell reference of the first code

Cheers
JulieD
 
hoganc,

A technique not yet mentioned is to use select your list, then use Data |
Filter... AutoFilter, and select Custom.

For the first row, select "Contains" in the left box, enter 233 in the box
to the right. Then select Or as the operator, and in the second row, select
"Contains" in the left box, and put 225 in the right box.

Then click OK and you're done - doesn't matter where in the string the 233
is located, so that may or may not matter...

HTH,
Bernie
MS Excel MVP
 
Back
Top