Filter function

Hi.
I made a list with four different types to filter on, lets say, A, B, C and D.
In one row, cell, (lets call it A&B row) i want to have A and B, so when i
filter my list after B, it shows the row, A&B. And when i filter after A, it
shows the row, A&B.
But when i filter after C, it do not show A&B.

My problem is, that when i enter A, B in the A&B row, cell, it only makes a
filter-option more in my list.
What should i write in the row, cell A&B, to make that work?

It is properly a simple function, but i can't find it anywhere.....

Brian

I'll try and make an example, so it perhaps will be more easy to understand.
A B (this is a list)
1 product Features in
2 Slide Room cover, portable
3 Sling Room cover, mobile, portable
4 Strap portable
5 Rail mobile

So when i try and sort/filter column B (the list), then i want to be able of
only finding those with "portable". (this should result in "Slide, Sling and
Strap)...

Hope this helps...

Brian



"Brian Brandt" skrev:

> Hi.
> I made a list with four different types to filter on, lets say, A, B, C and D.
> In one row, cell, (lets call it A&B row) i want to have A and B, so when i
> filter my list after B, it shows the row, A&B. And when i filter after A, it
> shows the row, A&B.
> But when i filter after C, it do not show A&B.
>
> My problem is, that when i enter A, B in the A&B row, cell, it only makes a
> filter-option more in my list.
> What should i write in the row, cell A&B, to make that work?
>
> It is properly a simple function, but i can't find it anywhere.....
>
> Brian

Hi Brian,

If you are using Data - Filter - Autofilter, then click on the arrow at the right of your filtering column you'll see some options at the top & then your list of values.
Click on the option "(Custom...)", you will get a popup dialog box and in the top left section it should say "equals" & have a dropdown arrow immediately to the right. Click on the arrow, scroll down, select "contains", tab into the right field & type "portable", and click ok.

Have a play, as you can see there are a number of ways of filtering when using the custom option.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

A B
1 product Features in
2 Slide Room cover, portable
3 Sling Room cover, mobile, portable
4 Strap portable
5 Rail mobile

SELECT A & B
ACTIVATE AUTOFILTER
DATA>FILTER>AUOTFILTER
PRESS ARROWHEAD ON COLUMN B
DROPDOWN LIST WILL APPEAR
SELECT CUSTOM
SELECT "CONTAINS"
TYPE "PORTABLE" IN OPPOSITE FIELD
PRESS OK
this should solve the problem
thanks

Not exactly what i was looking for, but it will do...
(I was hoping, that in the drop down menu, could choose "portable", and then
it would choose every row with portable).. but this can be used..

Thank you very much for the assistance.



"broro183" skrev:

>
> Hi Brian,
>
> If you are using Data - Filter - Autofilter, then click on the arrow at
> the right of your filtering column you'll see some options at the top &
> then your list of values.
> Click on the option "(Custom...)", you will get a popup dialog box and
> in the top left section it should say "equals" & have a dropdown arrow
> immediately to the right. Click on the arrow, scroll down, select
> "contains", tab into the right field & type "portable", and click ok.
>
> Have a play, as you can see there are a number of ways of filtering
> when using the custom option.
>
> hth
> Rob Brockett
> NZ
> Always learning & the best way to learn is to experience...
>
>
> --
> broro183
> ------------------------------------------------------------------------
> broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
> View this thread: http://www.excelforum.com/showthread...hreadid=535865
>
>

Hi Brian,

Thanks for the feedback, pleased I could help, the following may even help some more...

The dropdowns show entire cell values, therefore to be able to select "portable" from the dropdown you would have to have a column where the cell's value is "portable". You could possibly do this by using "text to columns" bu looking at your example values, "portable" wouldn't always be in the same column. I think a better solution to get it to work as you want is to use column C as a helper column & use an equation similar to the following:

=IF(ISNUMBER(FIND("portable",B1,1)),"portable","")

or if you want to provide more options for the filter dropdown of column C, you could nest consecutive tests (upto 7, I believe) within the "false" argument of the if statement, for example:

=IF(ISNUMBER(FIND("portable",B1,1)),"portable",IF(ISNUMBER(FIND("mobile",B1,1)),"mobile",""))

Once either of these formulae is copied down & included in the filter area you should be all go.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...