Forum Discussion

BW07's avatar
BW07
Copper Contributor
Feb 20, 2025
Solved

SORTBY Function

How do I limit the number of rows displayed by the SORTBY function? For example to only display the top 5 rows.
  • HansVogelaar's avatar
    Feb 20, 2025

    Use the TAKE function:

    =TAKE(SORTBY(...), 5)

Resources