If I used a formula =SORTBY(F6:G11,UNIQUE(G6:G11)) then it gives an #value error but the formula which I used as shown in the picture is unable to give me my desire

CodePudding user response：

You could try:

Formula in D1:

=UNIQUE(CHOOSE({1,2},XLOOKUP(B1:B6,B1:B6,A1:A6,,0),B1:B6))