How do I set up advance filters excel 2003

How do I set up advance filters excel 2003 using one column with mutlitple
entries. Auto filter allows only two entries and the numeric range varies.

Please advise.

What are your criteria? If you have multiple OR conditions you can use a
formula as criteria, use 2 cells as criteria and leave the firs one empty,
then in the cell below use

=OR(A2=criteria1,A2=criteria2,A2=criteria3,etc)

where A2 is the first cell with data in the column you want to filter then
in the criteria range refer to the empty cell and the cell with criteria
i.e. if you are using L1 and L2 use (L2 would be the cell with your formula
and L1 is empty)

$L$1:$L$2

as criteria



--

Regards,

Peo Sjoblom


"util" <[email protected]> wrote in message
news:[email protected]...
> How do I set up advance filters excel 2003 using one column with mutlitple
> entries. Auto filter allows only two entries and the numeric range
varies.
>
> Please advise.

You will need another set of cells that are your criteria. The first row in
the criteria must be the column headers from the main data table (the 'list
range') which will be used to filter. Ex: if your list range column
headers are Date, Sales and Weekday and you're going to filter on Weekday,
the criteria range must have Weekday (at least) in the first row. Each
subsequent row of the criteria range is one filter criteria; the result is
the union of all the filters (filter1 OR filter2 OR filter3 would be the
autofilter analogy). If you wanted to see the sales only on Monday, Tuesday
and Wednesday, for instance, the next three rows in your criteria range would
be 2, 3, 4.
Then select your data table and Data > Filter > Advanced Filter. Specify
the list range (Excel will fill this in for you if you selected the table
before turning on the filter) and the criteria range (the set of cells
including the headers on the criteria) and click OK.

"util" wrote:

> How do I set up advance filters excel 2003 using one column with mutlitple
> entries. Auto filter allows only two entries and the numeric range varies.
>
> Please advise.