You can use a helper column to set up an IF function to embody your
criteria and return, say, Yes or No. Then you can apply the filter to
that helper column.

Hope this helps.

Pete

On Jul 31, 11:01*am, Filtering more than two items <Filtering more
than two items @discussions.microsoft.com wrote:
i want to filter cells for more than one value and i dont want to do every
time manually. like currently from the filter drop down manue I am selecting
each item one by one (there are around 50 itmes out of a 20000 lines). i dont
want to reapet this manual selection every time. so please let me know incase
there is an option to select more than two items (because currntly excle
support only two text filters thru "contains" option).