Category - Other

List of user defined functions

ALLSHEETSReturns the min, max or sum of the identical cells across all worksheets.
COMMENTGETReturns the comment associated with a particular cell.
COMPARECELLSReturns a description of whether two ranges are identical or not.
DUPLICATECELLSReturns the cell addresses of all the items that appear more than once.
DUPLICATEVALUESReturns the list of items that appear more than once.
EMAILVALIDReturns whether a string is a valid email address.
EXTRACTFILENAMEReturns only the file name from a full file path.
EXTRACTFOLDERPATHReturns only the folder path from a full file path.
FINDMATCHReturns the position of an item in a list.
HYPERLINKGETReturns the hyperlink associated with a particular cell.
INVERSEReturns the number divided into 1.
MERGECELLSReturns the text string that is a concatenation of several strings or values.
NONBLANKVALUESReturns the contents of a cell range ignoring all the blank cells.
PERCENTAGEIFSReturns the percentage of values that satisfy multiple conditions.
RANDOMNUMBERReturns a random number between two intervals.
RANDOMPASSWORDReturns a specific number of random ASCII characters.
SELECTONEReturns 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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext