Question : google sheets select first n matches
Answered by : charlesalexandre-roy
# Basic syntax:
=QUERY(A:A,"Select A Limit 10")
# Where:
# - this selects the first 10 values from column A
# More advanced example:
=QUERY(A10:E,"Select A,B,C,D,E Order by C Desc Limit 5")
# Where:
# - this selects the first 5 rows on the range defined by A10:E that
# have been sorted in descending order by column CSource : https://infoinspired.com/google-docs/spreadsheet/extract-top-n-number-of-items-from-a-data-range-in-google-sheets/ | Last Update : Sun, 17 Jul 22