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" wrote in message
...
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.