Tip Printed from ExcelTip.com

---

Filtering a List into Unique Records Using the COUNTIF Formula


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.