advanced filter formula as a criteria

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

i have a column of data that looks like this:

12a
23d
12c
14d

I would like to use a formula in the advanced filter that
will filter down to cells that contain an a or c

thank you in advance.
 
For an Advanced Filter, in the criteria area, leave the heading cell blank.
In the cell below, enter a formula that refers to the first row of data
in the code column, e.g.:
=OR(ISNUMBER(SEARCH("a",A2)),ISNUMBER(SEARCH("c",A2)))

Or, in an AutoFilter, you could select Custom from the dropdown list
in the code column heading.
From the first dropdown, choose 'contains', and in the box, type: a
Change the operator to OR
From the second dropdown, choose 'contains', and in the box, type: c
Click OK
 
Hi
you have to use a helper column. If these values are in column A enter
the following formula
=IF(ISNUMBER(FIND("a",A1))+ISNUMBER(FIND("c",A1)),"X","")
now filter with this column
 
Use

=OR(ISNUMBER(SEARCH({"a";"c"},A5)))

where A5 would be the first cell with data, in your example A5 would hold
12a

assume you put this formula in F2 and leave F1 blank, then use

$F$1:$F$2

as criteria range

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top