» Filtering a Range into a List of Unique Records
CATEGORY - Excel Filter
VERSION - All Microsoft Excel Versions
To filter a range into a List of unique records:1. Select a cell the range (see screenshot).
2. From the Data menu, select Filter, and then Advanced Filter.
3. Select Copy to another location.
4. In the Copy to box, insert a cell address.
5. Select the Unique records only checkbox, and then click OK.
Book Store:
Recommended Books:
- The Guide to Understanding Financial Statements
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Microsoft Access 2002 for Dummies
- Microsoft Access Version 2002 Step by Step
- Microsoft Windows XP Inside Out
No comments have been submitted.
