This blog post describes how to filter unique distinct rows using an excel table. This post shows you how to do it using array formulas: Filter unique distinct records with a condition in excel 2007
The difference with today´s blog post is that you also can add more filters to your excel table, making the excel table a lot more useful.
What are unique distinct rows/records?
Unique distinct rows are all rows but duplicate rows are removed. See picture below.
Excel table example
We are now going to add a new column to the table. Select cell D2 and type this formula:
Filter unique distinct rows
- Click black arrow near header "Column1"
- Select 1
- Click ok!
Add another filter to the excel table
- Click black arrow near header "Products"
- Select "AA"
- Click OK!
Download excel 2007 *.xlsx file