Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Filter question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
.newman - 16 Mar 2008 11:48 GMT
I require to apply a double filter on more than on column but do not
know if it is possible.

e.g.

I wish to show all values of X in column A and all values of Y in column
B on the same filtered sheet. X and Y do not appear in any common row.
Is this possible?
Gary''s Student - 16 Mar 2008 12:37 GMT
It is possible, and you can have two variations:

Say this is our original data in cols A thru C:

first    second    values
A    other    1
A    other    2
A    other    3
other    other    4
other    B    5
A    other    6
other    B    7
A    B    8
A    other    9
A    B    10
other    B    11
other    B    12
other    other    13
other    B    14
other    B    15
other    other    16
other    other    17
A    other    18
A    B    19

If we switch on AutoFilter and select {A from column A} and {B from column
B}, we see:

first    second    values
A    B    8
A    B    10
A    B    19

However, if we want to see all rows having A in column A and B in column B,
then we can use a "helper" row.  In D2 enter:

=IF(OR(A2="A",B2="B"),1,0) and copy down:

first    second    values    helper
A    other    1    1
A    other    2    1
A    other    3    1
other    other    4    0
other    B    5    1
A    other    6    1
other    B    7    1
A    B    8    1
A    other    9    1
A    B    10    1
other    B    11    1
other    B    12    1
other    other    13    0
other    B    14    1
other    B    15    1
other    other    16    0
other    other    17    0
A    other    18    1
A    B    19    1

If we now AutoFilter on column D

first    second    values    helper
A    other    1    1
A    other    2    1
A    other    3    1
other    B    5    1
A    other    6    1
other    B    7    1
A    B    8    1
A    other    9    1
A    B    10    1
other    B    11    1
other    B    12    1
other    B    14    1
other    B    15    1
A    other    18    1
A    B    19    1

This gets us the "either/or" view.

Signature

Gary''s Student - gsnu2007f

> I require to apply a double filter on more than on column but do not
> know if it is possible.
[quoted text clipped - 4 lines]
> B on the same filtered sheet. X and Y do not appear in any common row.
> Is this possible?
.newman - 17 Mar 2008 12:41 GMT
Thank you

That is ideal.

Regards

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.