Functions Library
Date & Time
\CALENDAR
In-formula Calendar Template with dynamic formatting
\PARSEDATE
Parse date in any text format
Fun
2048 Lambda Port
Excel Lambda port of the famous mobile game
Lookup & Reference
\\ (The Double Backslash)
Make any formula immune to circular references
\FUZZYMATCH
User-friendly, powerful fuzzy-matching function for Excel. It’s like VLOOKUP that finds the most similar text.
Math & Trig
\RAND.STABLE
Stable, non-volatile version of the Excel RAND() function. Return the same random number on each recalculation.
\RANDARRAY.STABLE
Stable, non-volatile version of the Excel RANDARRAY() function. Return the same array of random numbers on each recalculation.
\RANDBETWEEN.STABLE
Stable, non-volatile version of the Excel RANDBETWEEN() function. Return the same random number on each recalculation.
\SHUFFLE
Single formula to randomly shuffle an Excel range
\SHUFFLE.ROWS
Single formula to randomly shuffle the rows of an Excel range
\SHUFFLE.ROWS.STABLE
Stable formula to randomly shuffle the rows of an Excel range. Does not change output on recalculation.
\SHUFFLE.STABLE
Stable formula to randomly shuffle an Excel range. Does not change output on recalculation.
Text
\GET.TAGS
Return all tags from the given cell.
\HAS.TAG
Check if cell has given tag. Great for formula-based conditional formatting.
\LEVENSHTEIN
First efficient Excel formula implementation of the Levenshtein distance function for measuring text similarity
\NGRAMS.DISTANCE
Fast edit distance function for text comparison
\STRIPACCENTS
The most complete accent-stripping function for Excel
\SUBSTITUTE.ALL
Replace nested SUBSTITUTE functions with one function.
\TAG
Add an invisible, zero-width, transferrable tag to a text value.
\UNTAG
Remove all tags added with \TAG.