INDEX Function – Google Sheets
The INDEX function retrieves a value from a cell within a range.
array
Conditionally Count Unique Values in Google Sheets
Three techniques to count unique values based on specified criteria.
UNIQUE Function – Google Sheets
Remove duplicate lines from a table of data
SORT Function in Google Sheets
Sort a range and output the dynamic results.
RANDARRY Function – Google Sheets
The RANDARRAY function generates and array of random decimals.