Nesting Array Functions: SORT, UNIQUE, and FILTER

August 19, 2022 - by Bill Jelen

Say that you want to filter the names in column B in Figure 625 so you get just the rows where the team in column A is Blue. Say also that you want to then get just the unique values and sort them. To do all this, you just use =SORT(UNIQUE(FILTER(B4:B29,A4:A29="Blue"),FALSE)).

Filter to just the blue team, get the unique names and sort them with =SORT(UNIQUE(FILTER(B4:B29,A4:A29="Blue"))).

Figure 628. Nesting array functions is no problem.

This article is an excerpt from Power Excel With MrExcel

Title photo by Siora Photography on Unsplash