muliple criteria filter

[BNT1 via OfficeKB.com]

hi

out of my depth with this formula, that was kindly supplied by this forum.
this was to put in helper column to isolate "307" in a group of numbers in a
cell, then use the filter to select 307. worked ok
=IF(ISERROR(FIND("307",A1)),"","incl. 307")

What I do require now is to isolate "307" and "936"

Is this something that can be grouped into one formula ?

As always, help appriciated
regards

 

[Dave Peterson]

So 307 or 936 are both ok?
=or(isnumber(find("307",a1)),isnumber(find("936",a1)))
Will return TRUE if either 307 or 936 is in A1.
It'll return False if neither 307 nor 936 is in A1.

You could wrap it in an =if() statement if you want:
=if(or(isnumber(find("307",a1)),isnumber(find("936",a1))),"Has at least one,"")

 

[Dennis Tucker]

Are these number you are interested in within one column?

If they are, I would use the autofilter.

Dennis