EXCEL : Applying SortBy for Unique-Filter function-CodePudding

Home > front end > EXCEL : Applying SortBy for Unique-Filter function

EXCEL : Applying SortBy for Unique-Filter function

Time：12-02

I got following issue in the Excel

I tried following functions but struggling to get the result I needed in column E

=UNIQUE(FILTER(SORTBY(A2:A15, C2:C15,1),B2:B15="EU", ""))

=LET(x, FILTER(A2:C5,B2:B15="EU",""), SORTBY(x,INDEX(x,0,3),1))

CodePudding user response：

Using: DROP() Function

• Formula used in cell G2

=LET(x,FILTER(A2:C15,B2:B15="EU"),UNIQUE(DROP(SORTBY(x,DROP(x,,2),1),,-2)))