Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to filter 7 columns in a 20 column spreadsheet?
I have tried using the advance filter unsuccessfully. the seven columns i
need to filter are not consecutive. any tips on filtering independant columns? |
#2
|
|||
|
|||
In the Extract range (Copy To), enter the headings that you want to extract. In the criteria area, use the headings and criteria that you need. When you run the Advanced Filter, select the entire table as the List range. Select the headings and criteria cells as the Criteria range. Select the Extract headings as the Copy To range. Yvette wrote: I have tried using the advance filter unsuccessfully. the seven columns i need to filter are not consecutive. any tips on filtering independant columns? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Column Chart labels on all columns | Charts and Charting in Excel | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
Filter two columns with criterion applying to one or the other? | Excel Discussion (Misc queries) |