Category - Other

List of user defined functions

ALLSHEETS	Returns the min, max or sum of the identical cells across all worksheets.
COMMENTGET	Returns the comment associated with a particular cell.
COMPARECELLS	Returns a description of whether two ranges are identical or not.
DUPLICATECELLS	Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES	Returns the list of items that appear more than once.
EMAILVALID	Returns whether a string is a valid email address.
EXTRACTFILENAME	Returns only the file name from a full file path.
EXTRACTFOLDERPATH	Returns only the folder path from a full file path.
FINDMATCH	Returns the position of an item in a list.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
INVERSE	Returns the number divided into 1.
MERGECELLS	Returns the text string that is a concatenation of several strings or values.
NONBLANKVALUES	Returns the contents of a cell range ignoring all the blank cells.
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.
SELECTONE	Returns a value at random from a range of cells.

ALLSHEETS Returns the min, max or sum of the identical cells across all worksheets.
COMMENTGET Returns the comment associated with a particular cell.
COMPARECELLS Returns a description of whether two ranges are identical or not.
DUPLICATECELLS Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES Returns the list of items that appear more than once.
EMAILVALID Returns whether a string is a valid email address.
EXTRACTFILENAME Returns only the file name from a full file path.
EXTRACTFOLDERPATH Returns only the folder path from a full file path.
FINDMATCH Returns the position of an item in a list.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
INVERSE Returns the number divided into 1.
MERGECELLS Returns the text string that is a concatenation of several strings or values.
NONBLANKVALUES Returns the contents of a cell range ignoring all the blank cells.
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.
SELECTONE Returns a value at random from a range of cells.