Ask Experts Questions for FREE Help !
Ask
    jgaska's Avatar
    jgaska Posts: 3, Reputation: 1
    New Member
     
    #1

    Jan 28, 2011, 02:14 PM
    excel filter
    I have a somewhat complex table that has multiple lists in Microsoft Excel, and I would like to filter. Additionally, I would like to have multiple filters within a single sheet, and need to specify the array that gets filtered, thus setting different values for the filter reference for each filter. Attached is a spreadsheet that hopefully will help clarify my question.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Jan 29, 2011, 07:42 AM

    The file is missing.

    You can't have more than one AUTOFILTER on a single sheet at one time.

    You CAN have more than one Excel LIST (or Excel TABLE if you're using 2007+). Select one of your ranges you want to filter and press CTRL-L to activate the List Wizard, then set the parameters for the list. Repeat for other data sections.

    An Excel LIST includes filters.
    jgaska's Avatar
    jgaska Posts: 3, Reputation: 1
    New Member
     
    #3

    Jan 29, 2011, 07:54 AM
    Comment on JBeaucaire's post
    Thanks so much. I guess my company computer didn't allow me to upload the file, hence the missing spreadsheet. But that is exactly what I wanted.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

The filter red light will not go off on refrigerator after filter is replaced [ 2 Answers ]

Maytag plus filter warning light will not go off when filter is replaced

Excel Filter Macro needed [ 10 Answers ]

I have a list and want to filter it with reference to a cell. e.g. list is ranging from Row 5 to 2000, I want to assigne Cell A4 as reference to filter the data. When something is entered in A4 then it should check that A5 to A2000 has that data or not if yes then filter or else don't execute and...

Pump won't lite after cleaning filter and inner filter [ 1 Answers ]

Filter was complet mush and guk, also in the pump I took out and cleaned the screen , all good now, I primed filter and pump but still would not ignite. Blnk blk blk, after 3 second hold button furnace attempts then must hold for 30 secs to reset from lockout. SO after many attemps, "does it every...

Filter from 2 Columns (Unique values) in Excel [ 1 Answers ]

I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143


View more questions Search