Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR EXCEL

google sheets select first n matches

# 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 C
Source by infoinspired.com #
 
PREVIOUS NEXT
Tagged: #google #sheets #select #matches
ADD COMMENT
Topic
Name
8+7 =