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 / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

Filtering Multiple Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TJ - 16 Oct 2006 18:13 GMT
I am helping a friend with this and I believe he is using Excel 2000.

I  need to filter on multiple, non-concurrent columns.   When I select the
multiple columns I am told it has to be in a range.  Is there any way around
this?

Signature

TJ

CLR - 16 Oct 2006 18:16 GMT
Using AutoFilter......just filter on the columns one at a time.......

Vaya con Dios,
Chuck, CABGx3

> I am helping a friend with this and I believe he is using Excel 2000.
>
> I  need to filter on multiple, non-concurrent columns.   When I select the
> multiple columns I am told it has to be in a range.  Is there any way around
> this?
TJ - 16 Oct 2006 18:33 GMT
I tried that, but the second column I pick, auto-filter just toggles the
filter off for the first column.
Signature

TJ

> Using AutoFilter......just filter on the columns one at a time.......
>
[quoted text clipped - 6 lines]
> > multiple columns I am told it has to be in a range.  Is there any way around
> > this?
Roger Govier - 16 Oct 2006 18:44 GMT
Hi

Mark the complete range of data.
Data>Filter>Autofilter
You will have dropdowns on all columns (including any blank columns)
Select the first column you wish to filter by, chose what you want via
the dropdown. You will now have a filtered list.
Select any OTHER dropdown, and make a further selection. and the list
will be further filtered.

repeat as many times as you wish.

Signature

Regards

Roger Govier

>I tried that, but the second column I pick, auto-filter just toggles
>the
[quoted text clipped - 13 lines]
>> > way around
>> > this?
TJ - 16 Oct 2006 18:53 GMT
I don't think I'm asking my question correctly.  I only want certain columns
filtered, not all.  And these columns are not consecutive, they are random in
order.  I'm not even sure this is possible.
Signature

TJ

> Hi
>
[quoted text clipped - 25 lines]
> >> > way around
> >> > this?
Roger Govier - 16 Oct 2006 19:03 GMT
You cannot filter just within a column.
Rows are contiguous and if a column is filtered, then all data in the
row selected is either displayed or hidden dependent upon your
criterion, not just the individual cells within the column upon which
you have placed the filter.

Signature

Regards

Roger Govier

>I don't think I'm asking my question correctly.  I only want certain
>columns
[quoted text clipped - 34 lines]
>> >> > way around
>> >> > this?
Pete_UK - 16 Oct 2006 19:12 GMT
TJ,

let's imagine that you want to apply a filter condition to columns A, F
and H - as Roger says, highlight all the data in the range A to H
(including any headings) and click Data | Filter | Autofilter (check).
This will give you pull-downs on all the columns, but you don't have to
use them all. Apply your filter to column A, then to column F, and then
to column H, to give you the effect that you want.

Hope this helps.

Pete

> I don't think I'm asking my question correctly.  I only want certain columns
> filtered, not all.  And these columns are not consecutive, they are random in
[quoted text clipped - 38 lines]
> > >> > way around
> > >> > this?
Kevin Vaughn - 16 Oct 2006 21:21 GMT
Apparently, this can only be done using VBA.  I remembered reading about
this, but could not remember the details until I looked it up in one of my
Excel VBA books: VBA and Macros for Microsoft Excel by Bill Jelen "Mr. Excel"
and Tracy Syrstad.

I experimented with it, took an existing Autofilter that began in A2, and
turned off the indicated columns:
(D, E, F, H, and I)
Sub TestFilter()
   Range("a2").AutoFilter field:=4, visibledropdown:=False
   Range("a2").AutoFilter field:=5, visibledropdown:=False
   Range("a2").AutoFilter field:=6, visibledropdown:=False
   Range("a2").AutoFilter field:=8, visibledropdown:=False
   Range("a2").AutoFilter field:=9, visibledropdown:=False
End Sub

Signature

Kevin Vaughn

> I don't think I'm asking my question correctly.  I only want certain columns
> filtered, not all.  And these columns are not consecutive, they are random in
[quoted text clipped - 29 lines]
> > >> > way around
> > >> > this?
TJ - 17 Oct 2006 13:09 GMT
That is EXACTLY what I was looking for.  I will give it a try.  Thanks.
Signature

TJ

> Apparently, this can only be done using VBA.  I remembered reading about
> this, but could not remember the details until I looked it up in one of my
[quoted text clipped - 45 lines]
> > > >> > way around
> > > >> > this?
Kevin Vaughn - 17 Oct 2006 17:09 GMT
You're welcome.
Signature

Kevin Vaughn

> That is EXACTLY what I was looking for.  I will give it a try.  Thanks.
 
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.