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...

  • pls share a copy of your sheet – user0 Jul 26 '19 at 19:34

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)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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