existsInColumn

Overview
Check if a value is in a list of elements (or an G. Sheets column)
You can combine this function with the combineAll function in order to check if one value is present in several columns
Video Example
Arguments
value: The value to check if exists in a column
column: The column of items to search in
Expected Output
Boolean: True or False if the element exists or not
Text example
existsInColumn("JohnMu", A3:A6) 
// Column values: apple, banana, JohnMu, Cheese
// Returns True
Use cases
Check if a value is present in a column

combineAll

groupByCell

Last modified 7mo ago