View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
 
Posts: 125
Default muliple criteria filter

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