FormulaCraft

SORT

SORT returns a sorted copy of a range, spilling the result. Choose which column to sort by and the direction. Available in Excel 365 and Google Sheets.

Excel
=SORT(A2:B100, 2, FALSE)
Google Sheets
=SORT(A2:B100, 2, FALSE)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:B100 is the range to sort.
  2. 22 sorts by the 2nd column.
  3. 3FALSE sorts descending; TRUE sorts ascending.

Need a version for your data?

Try: “Sort the table A2:B100 by the second column, largest first”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: