Filter on more than one cells (text)

[Filtering more than two items]

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).

 

[Pete_UK]

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

 

[Spiky]

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).

Use Advanced Filter instead. You can have a criteria area setup and
just enter in the items you need each time, faster than picking from
the Autofilter drop-downs. And you can use whatever means you want to
get the criteria in place, formulas, copy/paste, etc.