advance filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if anybody knows how to use advance filters if you want
to select only nubers that begins with 572. For example I want to select all
the number in a list that star with 572.... I need to do it with advance
filters because I have to use more filters in others columns.

Thank you.

Manuel
 
Hi Manuel,

Perhaps you could add a helper column and filter on the helper column?

Assume the relevant data to be in cells B2:B100:

Insert a helper C column
In Cell C2 enter the formula =Left(B2, 3) = 572
Copy down to C100
Filter on column C using TRUE as the filter condition.
 
Hi!

No need for a helper column. Just change the formula
slightly to:

=--LEFT(B2,3)=572

Now enter that formula in a cell and make sure the cell
above is left blank.

For example, enter the formula in H2 and make sure H1 is
empty.

In the advanced filter criteria range, enter H1:H2.

Biff
 
Back
Top