SORT Function in Google Sheets
Sort a range and output the dynamic results.
array
RANDARRY Function – Google Sheets
The RANDARRAY function generates and array of random decimals.
TYPE Function – Google Sheets
The TYPE function checks a cell and returns the data type as an integer. Several types of data are allowed in a Google Sheet, and knowing the type helps you understand how to use it. More specific functions are available to determine a cell’s data type, but they only return TRUE or FALSE. For example, … Read more
SORTN Function in Google Sheets
Learn how to sort a range of data and return the first n items with the SORTN function.
ARRAYFORMULA Function – Google Sheets
The ARRAYFORMULA function is a powerful tool in Google Sheets that allows you to spread formula outputs across multiple rows and columns. It can extend non-array functions such as SUM, PRODUCT, or AVERAGE. As with other functions that generate arrays, such as FILTER and QUERY, the output needs space to expand below and right. Keep … Read more