» Filtering by More Than Two Criteria
CATEGORY - Excel Filter
VERSION - All Microsoft Excel Versions
1. Insert a few empty rows above the List.
2. Copy the heading row List, and paste it into row 1.
3. In row 2, under Customer Name (for example, see the screenshot), enter a Customer Name; under Quantity, enter the criteria.
4. From the Data menu, select Filter, and then Advanced Filter.
5. Select the List range box and insert the List range.
6. Select the Criteria range box and insert the criteria range.
7. Click OK.
Book Store:
Status Bar
Moshe Posted on: 31-12-1969
What you get there? Why it change after pressing F9 for example?Advanced Filters and shared workbooks
Lou Bergner Posted on: 31-12-1969
Is is possible to use advanced filters in a shared workbook? I thought I had it working and invoked it with a macro, but it seems not to be working anymore. Is this just not allowed in shared workbooks?
Thank you,
Lou
F9
Deanna Posted on: 31-12-1969
F9 will cause your spreadsheet to calculate, if it is set up to calculate manually. To change to automatic calculation: Tools\Options\Calculation Can you Copy Comments using Advanced Filter
Mike Posted on: 31-12-1969
When using the advanced filter to copy to another location, is there any simple way to bring the comments over as well? The advanced filter is such an amazing feature, but if I can't bring the comments over too, I might as well do it all another way in VBA anyway, bummer, I was soooo happy about all thisExcel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
