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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1

So 307 or 936 are both ok?
=or(isnumber(find("307",a1)),isnumber(find("936",a 1)))
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,"")




"BNT1 via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1

--

Dave Peterson