🍔

Free generic functions

Check all the free utilities available, its cost and how to use them

Overview
The free functions are the ones that you can use indefinitely when you've install Unlimited Sheets.
We don't provide support for free functions as they are built with free external APIs that we don't own so we cannot solve certain issues. 
All the free functions that rely on external API have they own improved version as a Premium function which we control and we give support
We have two types of free functions: SEO specifics & general utilities to improve the Spreadsheets experience
Name
Short description
​combineAll​
Combine horizontal & vertical columns in just one vertical column
​existsInColumn​
Check if a value is in a list of elements (or an G. Sheets column)
​groupByCell​
Group a number of cells in only one
​myReplace​
Replace a string or substring for another one, you can use a string or a Regex
​returnCellInversed​
Returns the value of a specific value by its inversed position filtering empty/falsy values
​returnLastCell​
Returns the last value of an array of cells filtering empty & falsy values
​v2lookup​
Vertical lookup using two elements to find an output
​unlimitedVlookup (beta)
Vertical lookup using unlimited elements to find an output

Name	Short description
combineAll	Combine horizontal & vertical columns in just one vertical column
existsInColumn	Check if a value is in a list of elements (or an G. Sheets column)
groupByCell	Group a number of cells in only one
myReplace	Replace a string or substring for another one, you can use a string or a Regex
returnCellInversed	Returns the value of a specific value by its inversed position filtering empty/falsy values
returnLastCell	Returns the last value of an array of cells filtering empty & falsy values
v2lookup	Vertical lookup using two elements to find an output
unlimitedVlookup (beta)	Vertical lookup using unlimited elements to find an output

getSearchVolume

combineAll

Last modified 4mo ago