Category - Other

List of user defined functions

BETWEENReturns whether a particular cell value is between a range of values.
COLUMNWIDTHReturns the column width of the active cell.
COMMENTGETReturns the comment associated with a particular cell.
EXTRACTFILENAMEReturns just the file name from a full file path.
EXTRACTFILEPATHReturns just the file path from a full file path.
FILEEXISTSReturns whether a particular file exists.
FINDMATCHReturns the position of an item in a list.
FOLDEREXISTSReturns whether a particular folder exists.
HYPERLINKGETReturns the hyperlink associated with a particular cell.
INVERSEReturns the number divided into 1.
LASTINCOLUMNReturns the last cell that contains data in a particular column.
LASTINROWReturns the last cell that contains data in a particular row.
PERCENTAGEIFSReturns the percentage of values that satisfy multiple conditions.
RANDOMNUMBERReturns a random number between two intervals.
RANDOMPASSWORDReturns a specific number of random ASCII characters.
REMOVEBLANKSReturns the contents of a cell range ignoring all the blank cells.
REMOVEDUPLICATESReturns the contents of a cell range ignoring all the duplicate values.
REVERSEReturns the cell contents with all the characters reversed.
ROWHEIGHTReturns the row height of the active cell.
SCRAMBLEReturns the contents of a cell with all the characters in a random order.
SELECTONEReturns a value at random from a range of cells.
UNIQUEITEMSReturns 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.

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