Filter for 225 or 233 numbers

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

hoganc

thanks Julie that seems to be workign better


how did you learn all this stuff????
 
Hi

glad it's getting close to being solved :)

most of the stuff i know i learnt from these newsgroups :) and a bit of
trial & error

Cheers
JulieD
 
<"glad it's getting close to being solved :)">
Don't understand you here Julie.
Your formula *does* solve it, doesn't it?

If OP wants the actual number returned, and your formula equates to True or
False, just add the "IF":

=IF(AND(LEN(A1)>=7,OR(LEFT(RIGHT(A1,7),3)="225",LEFT(RIGHT(A1,7),3)="233")),
A1,"")
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------



Hi

glad it's getting close to being solved :)

most of the stuff i know i learnt from these newsgroups :) and a bit of
trial & error

Cheers
JulieD
 
Hi RD

wasn't sure if "that seems to be workign better " meant it was fixed or not
:)

i'm sure the OP will let us know if he needs more assistance.

Cheers
JulieD
 
You must log in or register to reply here.

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

Filter for 225 or 233 numbers 3
Filter for 225 or 233 numbers 4
Filter for 225 or 233 numbers 3
A Search for 233 and 225 numbers??? 2
The lowest of all? 6
Filter for 225 or 233 numbers 2
Using Index across several columns 3
Count unique distinct values that meet multiple criteria 1

Back
Top