» 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:
- Special Edition Using Microsoft Excel 2002
- Excel 2002 Power Programming with VBA
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Special Edition Using Microsoft Access 2002
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
