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.
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.
XLOOKUPINTERPOLATE	*Returns an interpolated value if an exact match is not found.

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.
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.
XLOOKUPINTERPOLATE *Returns an interpolated value if an exact match is not found.