Top Rows Only
Key points
- Choose SORTN
- Enter the count
- Copy it
In SORT Builder you can return only the number of rows you give from the top.
Steps
- Choose SORTN
- Enter the count
- Copy it
In Excel it becomes a formula combining SORT and TAKE.
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.