Excel Functions Category

List of user defined functions

BETWEEN	Returns whether a particular cell value is between a range of values.
COLUMNWIDTH	Returns the column width of the active cell.
COMMENTGET	Returns the comment associated with a particular cell.
EXTRACTFILENAME	Returns just the file name from a full file path.
EXTRACTFILEPATH	Returns just the file path from a full file path.
FILEEXISTS	Returns whether a particular file exists.
FINDMATCH	Returns the position of an item in a list.
FOLDEREXISTS	Returns whether a particular folder exists.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
IFERROR	Returns a value or something else when it returns an error.
INVERSE	Returns the number divided into 1.
LASTINCOLUMN	Returns the last cell that contains data in a particular column.
LASTINROW	Returns the last cell that contains data in a particular row.
PERCENTAGEIF	Returns the percentage of numbers in a range that meet a particular condition.
PERCENTAGEIFS
RANDOMNUMBER	Returns a random number between two intervals.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVENUMBERS	Returns any numbers from a text string.
REMOVESPACES	Returns a text string with any spaces removed.
REVERSE	Returns the cell contents with all the characters reversed.
ROWHEIGHT	Returns the row height of the active cell.
SCRAMBLE	Returns the contents of a cell with all the characters in a random order.
SELECTONE	Returns a value at random from a range of cells.
UNIQUEITEMS	Returns an array of all the unique items in a range.

BETWEEN Returns whether a particular cell value is between a range of values.
COLUMNWIDTH Returns the column width of the active cell.
COMMENTGET Returns the comment associated with a particular cell.
EXTRACTFILENAME Returns just the file name from a full file path.
EXTRACTFILEPATH Returns just the file path from a full file path.
FILEEXISTS Returns whether a particular file exists.
FINDMATCH Returns the position of an item in a list.
FOLDEREXISTS Returns whether a particular folder exists.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
IFERROR Returns a value or something else when it returns an error.
INVERSE Returns the number divided into 1.
LASTINCOLUMN Returns the last cell that contains data in a particular column.
LASTINROW Returns the last cell that contains data in a particular row.
PERCENTAGEIF Returns the percentage of numbers in a range that meet a particular condition.
PERCENTAGEIFS
RANDOMNUMBER Returns a random number between two intervals.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVENUMBERS Returns any numbers from a text string.
REMOVESPACES Returns a text string with any spaces removed.
REVERSE Returns the cell contents with all the characters reversed.
ROWHEIGHT Returns the row height of the active cell.
SCRAMBLE Returns the contents of a cell with all the characters in a random order.
SELECTONE Returns a value at random from a range of cells.
UNIQUEITEMS Returns an array of all the unique items in a range.