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.
IFERRORReturns a value or something else when it returns an error.
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.
PERCENTAGEIFReturns the percentage of numbers in a range that meet a particular condition.
PERCENTAGEIFS 
RANDOMNUMBERReturns a random number between two intervals.
RANDOMPASSWORDReturns a specific number of random ASCII characters.
REMOVENUMBERSReturns any numbers from a text string.
REMOVESPACESReturns a text string with any spaces removed.
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.
IFERROR
Returns a value or something else when it returns an error.
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.
PERCENTAGEIF
Returns the percentage of numbers in a range that meet a particular condition.
PERCENTAGEIFS
RANDOMNUMBER
Returns a random number between two intervals.
RANDOMPASSWORD
Returns a specific number of random ASCII characters.
REMOVENUMBERS
Returns any numbers from a text string.
REMOVESPACES
Returns a text string with any spaces removed.
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.

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