Category - Other
List of user defined functions
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. |
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. |
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. |
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. |
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. |
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. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext