EXCEL TIPS & TRICKS

Advanced Filter in Microsoft Excel

BUY | Excel Tips & Tricks Start

1) Criteria

This screen shot demonstrates how to use complex computed criteria.

You can filter your list by group automatically by selecting a category.

If you want to restore your list, just select "Show All".

A few lines of VBA codes support this automation.

If you want to filter overall top three products, use the criteria for Filter # 2.

2) Copy filtered data to a different sheet.

Filtering your filtered data to a different sheet is tricky. Excel says it can't be done. We show you how to get around the problem step-by-step.

Part 6: Other Tips

1. Delete or change names quickly without using the Define Name (Insert>Name>Define) dialog box.

How to rename a filled range without deleting the contents of the range.
How to delete the name, keeping the contents of the range.
How to delete both the name and the contents of the range.
How to delete a name for an empty named range.

2. How to assign self-adjusting sequential numbers to items in your list.

You need to number items in your list sequentially. You sometimes delete items from your list or add new items to the list. You want those item numbers
adjusted automatically every time you add or delete items.

3. How to make a replica of a single regular of array formula:

You are going to edit your formula and want to back it up.
You do not want the original cell references changed.

4. Navigation Tips in your VBE window:

5. How to locate a VBA procedure quickly in the VBE.

You have multiple public procedures scattered all over multiple standard modules and want to find a particular procedure quickly. Our tip comes in handy if you don’t remember the name of your macro

More Excel Tips & Tricks

Excel Tips & Tricks Start & Find Your Excel VBA Procedure Quickly From Your Workbook Window & Alternatives to Excel Array Formulas & Sumproduct & Other Useful Regular Excel Formulas & Advanced Filter & Other Tips

BACK TO Excel Tips & Tricks Start

Excel Tips & Tricks $19.95 Payment Problems/Options Instant Buy/Download 30 Day Money Back Guarantee

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Training Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft