1

I'm currently using UNIQUE to look through a spreadsheet and display in another spreadsheet all the unique names in a certain "Name" column.

However, I need to sort these names by another column that is to the right of the Name column.

How do you combine them together? I've tried sort in from of Unique but I'm not sure how to sew the 2 together...

0

3 Answers 3

0

An example could be SORTN restricted by INDEX where the 3rd parameter of SORTN is 2

=INDEX(SORTN(A2:B, ROWS(A2:A), 2, 2, 1), , 1)

0

0

The simplest solution is to simply SORT the "Name" column based on the sort column (B in the formula), then filter for UNIQUE values.

=UNIQUE(SORT(A2:A,B2:B,1))
-1

concatenate the two columns then sort(unique()) the result. Then separate them back out again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.