Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
Using AutoFilter......just filter on the columns one at a time.......
Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
I tried that, but the second column I pick, auto-filter just toggles the
filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
Hi
Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
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. -- TJ "Roger Govier" wrote: Hi Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
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. -- Regards Roger Govier "TJ" wrote in message ... 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. -- TJ "Roger Govier" wrote: Hi Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
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 TJ wrote: 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. -- TJ "Roger Govier" wrote: Hi Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
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 -- Kevin Vaughn "TJ" wrote: 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. -- TJ "Roger Govier" wrote: Hi Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
That is EXACTLY what I was looking for. I will give it a try. Thanks.
-- TJ "Kevin Vaughn" wrote: 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 -- Kevin Vaughn "TJ" wrote: 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. -- TJ "Roger Govier" wrote: Hi Mark the complete range of data. DataFilterAutofilter 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. -- Regards Roger Govier "TJ" wrote in message ... I tried that, but the second column I pick, auto-filter just toggles the filter off for the first column. -- TJ "CLR" wrote: Using AutoFilter......just filter on the columns one at a time....... Vaya con Dios, Chuck, CABGx3 "TJ" wrote: 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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering Multiple Columns
You're welcome.
-- Kevin Vaughn "TJ" wrote: That is EXACTLY what I was looking for. I will give it a try. Thanks. -- TJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Multiple Columns | Excel Worksheet Functions | |||
Selecting different multiple columns | Excel Worksheet Functions | |||
making multiple columns when printing long datasheet | Excel Discussion (Misc queries) | |||
splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
drop down list multiple columns | Excel Discussion (Misc queries) |