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.
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.
PERCENTAGEIFS	Returns the percentage of values that satisfy multiple conditions.
RANDOMNUMBER	Returns a random number between two intervals.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVEBLANKS	Returns the contents of a cell range ignoring all the blank cells.
REMOVEDUPLICATES	Returns the contents of a cell range ignoring all the duplicate values.
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.
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.
PERCENTAGEIFS Returns the percentage of values that satisfy multiple conditions.
RANDOMNUMBER Returns a random number between two intervals.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVEBLANKS Returns the contents of a cell range ignoring all the blank cells.
REMOVEDUPLICATES Returns the contents of a cell range ignoring all the duplicate values.
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.