Filter on more than one cells (text)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Filtering more than two items - 31 Jul 2008 11:01 GMT

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

Reply to this Message

Pete_UK - 31 Jul 2008 11:43 GMT

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

Reply to this Message

Spiky - 31 Jul 2008 20:39 GMT

On Jul 31, 5:01 am, Filtering more than two items <Filtering more than
two items @discussions.microsoft.com> wrote:

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.

Reply to this Message