New answers tagged

0 votes

Sorting a range of data based on a column within that data

To sort column A by column P, use sort(), like this: =sort(A2:A, P2:A, false) To get just a limited number of results, use sortn(). See sort() and sortn().
doubleunary's user avatar
  • 14.5k

Top 50 recent answers are included