» Filtering a List into Unique Records Using the COUNTIF Formula
CATEGORY - Excel Filter
VERSION - All Microsoft Excel Versions
To filter a List into unique records using the COUNTIF formula:1. Select cell B2, and insert the formula =IF(COUNTIF($A$2:A2,A2)1,1,0).
2. Copy the formula from cell B2 downwards.
3. From the Data menu, select Filter, AutoFilter.
4. Select cell B1 and press Alt+Down Arrow to open the filtering dropdown list or open it by clicking the dropdown arrow and then selecting 0.
Book Store:
Recommended Books:
- Absolute Beginner's Guide to Microsoft Excel 2002
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Special Edition Using Microsoft Excel 2002
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Special Edition Using Microsoft Access 2002
- The Ernst & Young Business Plan Guide
No comments have been submitted.
