Re: muliple criteria filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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,"")




"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.aspx/ms-excel/200910/1

--

Dave Peterson
.

Relevant Pages

  • Re: Filter data
    ... the filter should not be attempted by the code when the ... > Hi Murthy ... > Regards Ron de Bruin ... as soon as the value in Cell A1 is changed? ...
    (microsoft.public.excel.misc)
  • Re: Conditional Filtering with cell format
    ... Thanks for your suggestions and kindly devise an excel VBA code (ie ... Regards ... > Filter work on cell values, so you would need to write User Defined ...
    (microsoft.public.excel.programming)
  • Re: CSV Newbie Question
    ... format the cell to wrap text ... Regards, ... Tom Ogilvy ... > how do you start a new line within a cell? ...
    (microsoft.public.excel.programming)
  • Re: Autofit and word wrap dont work?
    ... When I enter text in a wrap-text autofit cell the text ... of the characters hidden if they are below the magic threshold. ... is a method to wrap as soon as a character string exceeds what can be seen. ...
    (microsoft.public.excel.misc)
  • Re: Can I auto format row height according to requirements of largest cell in row? Format > Rows >
    ... row adjusts height to fit as long as wrap text is enabled. ... If you set all the cells in the row to autofit and wrap text, ... Gord Dibben MS Excel MVP ...
    (microsoft.public.excel)