Skip to content

SORT in Excel

Published: Oct 19, 2026 | Updated: Oct 19, 2026 | About (Japanese)

Key points

Enter the range
See the Excel formula
Copy it

SORT Builder shows a formula for Excel (365) as well.

Steps

Enter the range
See the Excel formula
Copy it

Older Excel versions do not have the SORT function.

Use "Build a SORT Formula" (free)

Tools that go well with this

Build a FILTER Formula: Build a FILTER formula.
Build a QUERY Formula: Build a QUERY formula.
Build a UNIQUE Formula: Build duplicate-handling formulas.

If this guide helped, a small tip would mean a lot.

Send a tip (¥300)Send a gift (Amazon wishlist)

More guides for this tool