ANSI128 strips the accents from a string
CHBASE converts a value from a base into another base.
COUNTDIFF number of unique values in a range or array
COUNTIF.3D same as COUNTIF working with 3D references
DATE.DIFF returns an age in years, months and days
EASTERDATE date of Easter Sunday for a given year
EVAL evaluates a formula or expression
FILENAME name of the workbook
FORMULATEXT returns the formula of a cell
GEOMEAN.EXT same as GEOMEAN, higher capacity
HSORT sorts a range or an array (supports up to 14 sort keys) - vertical
HSORT.IDX sort index of a range or array (supports up to 14 sort keys) - vertical
INDIRECT.EXT same as INDIRECT working also with closed workbooks
INTVECTOR returns a vector of consecutive integers in the ascending order
ISO.WEEKNUM ISO-compliant week number of a day
LASTROW last filled cell in a column
MATRIXROUND adjusts an array of rounded numbers (=>sum of percentages = always 100%)
MCONCAT concatenates all values in a range or an array
MDETERM.EXT same as MDETERM, faster and supporting larger arrays
MINVERSE.EXT same as MINVERSE, faster and supporting larger arrays
MMAX returns the N highest numbers of a range or an array
MMIN returns the N lowest numbers of a range or an array
MMULT.EXT same as MMULT, faster and supporting larger arrays
MRAND series of random integers without repetitions
NBTEXT converts a positive number into spelled-out text (supports 13 languages)
PAGENUM page number of a cell
PN.ISPRIME returns TRUE if a number is a prime number (up to 255 digits)
PN.NEXT returns the next prime number (up to 255 digits)
RECALL returns the previous value of the calling cell before the last calculation
REGEX.COMP returns TRUE if a text matches a regular expression
REGEX.COUNT counts the matches of a regular expression in a string
REGEX.FIND location of a substring matching a regular expression
REGEX.LEN length of a substring matching a regular expression
REGEX.MID returns a substring matching a regular expression
REGEX.SUBSTITUTE replaces a substring matching a regular expression with a new string
SETV,GETV allow to use temporary variables in worksheet formulae
SHEETNAME name of a sheet in the workbook
STDEV.GROUPED standard deviation based on a sample (data grouped in classes)
STDEVP.GROUPED standard deviation based on the entire population (grouped data)
THREED coerces a 3D range into a single array - enables array formulae with 3D references
UNIQUEVALUES returns the unique items of a range or an array
VAR.GROUPED variance based on a sample (data grouped in classes)
VARP.GROUPED variance based on the entire population (grouped data)
VSORT sorts a range or an array (supports up to 14 sort keys) - horizontal
VSORT.IDX sort index of a range or array (supports up to 14 sort keys) - horizontal
WEIGHTED.AVERAGE returns a weighted average
WORDCOUNT number of words in a text
WMID extracts a word or a group of words from a text