User Defined Functions Complete List
ACRONYM | Returns the first letter of each word. |
AGE | Returns the age of a person given a birthday. |
ALLSHEETS | Returns the min, max or sum of the identical cells across all worksheets. |
AVERAGEAVISIBLE | Returns the average value from the visible, non blank cells in a range (including logical values and text). |
AVERAGEIFSVISIBLE | Returns the average value from the visible, non blank cells that satisfy multiple conditions. |
AVERAGETOP | Returns the average value from the cells with the top "x" values or percentage. |
AVERAGEVISIBLE | Returns the average value from the visible, non blank cells. |
CELLTYPE | Returns the type of value that is contained in a particular cell. |
COLUMNWIDTH | Returns the column width of a particular cell. |
COMMENTGET | Returns the comment associated with a particular cell. |
COMPUTERNAME | Returns the full computer name. |
CONTAINS | Returns whether a string is contained inside another string. |
COUNTAVISIBLE | Returns the number of visible, non blank cells in a range (including logical values and text). |
COUNTBETWEEN | Returns the number of cells that have a value that is between a range. |
COUNTFORMAT | Returns the number of cells that have a particular cell color or font color. |
COUNTIFSVISIBLE | Returns the number of visible, non blank cells that satisfy multiple conditions. |
COUNTNUMBEROFDAYS | Returns the number of days in a particular month or year. |
COUNTSUBSTRING | Returns the number of occurrences of a substring in a particular cell. |
COUNTTEXTCELLS | Returns the number of cells that contain text. |
COUNTVISIBLE | Returns the number of visible, non blank cells in a range. |
DATEUNITS | Returns the number of units between two dates. |
DATESBEFORE1900 | Returns the results of adding and subtracting dates before 1900 which are represented as text. |
DATEWHICHDAY | Returns the date given a month, a week number and a day of the week. |
DAYSTOCHRISTMAS | Returns the number of days to Christmas. |
EXCELDIR | Returns the various folder locations that Excel uses including installation and startup. |
EXTRACTFILENAME | Returns only the file name from a full file path. |
EXTRACTFILEPATH | Returns only the file path from a full file path. |
EXTRACTFOLDERPATH | Returns only the folder path from a full file path. |
EXTRACTNUMBERS | Returns only the numbers from a text string. |
EXTRACTTEXT | Returns only the text from a text string that contains other characters as well. |
FILEEXISTS | Returns whether a particular file exists. |
FILEPROPERTIES | Returns built-in or custom document properties from the active workbook. |
FINDMATCH | Returns the position of an item in a list. |
FIRSTDATE | Returns the date of the first day of a week, month or year. |
FIRSTWORD | Returns the first word from a text string. |
FOLDEREXISTS | Returns whether a particular folder exists. |
FORMATGET | Returns a specific formatting attribute from a particular cell. |
HLOOKUPINTERPOLATE | Returns an interpolated value if an exact match is not found. |
HYPERLINKGET | Returns the hyperlink associated with a particular cell. |
IMAGEDISPLAY | Returns an image in the top left corner of the active cell. |
INSERTSTRING | Returns the text string with a substring inserted in the middle. |
INVERSE | Returns the number divided into 1. |
ISBETWEEN | Returns whether a particular cell value is between a range. |
ISBOLD | Returns whether a particular cell has been formatted in bold. |
ISDATE | Returns whether a date is the first (or last) of a week, month or year. |
ISFORMULA | Returns whether a particular cell contains a formula. |
ISINTEGER | Returns whether a particular cell contains an integer number. |
ISITALIC | Returns whether a particular cell has been formatted in italic. |
ISLIKE | Returns whether a particular cell contains a string that matches a certain pattern. |
ISLOCKED | Returns whether a particular cell has been locked. |
ISLOWER | Returns whether a particular cell has been formatted in lower case. |
ISMERGED | Returns whether a particular cell has been merged. |
ISPRIME | Returns whether a particular cell contains a prime number. |
ISPROPER | Returns whether a particular cell has been formatted in proper case. |
ISUNDERLINE | Returns whether a particular cell has been formatted in underline. |
ISUPPER | Returns whether a particular cell has been formatted in upper case. |
ISWRAPPED | Returns whether a particular cell has been formatted with text wrap. |
LASTDATE | Returns the date of the last day of a week, month or year. |
LASTINCOLUMN | Returns the last cell that contains data in a particular column. |
LASTINROW | Returns the last cell that contains data in a particular row. |
LASTWORD | Returns the last word from a text string. |
MAXAVISIBLE | Returns the largest value from the visible, non blank cells (including logical values and text). |
MAXBETWEEN | Returns the largest value that is between a range. |
MAXIFSVISIBLE | Returns the largest value from the visible, non blank cells that satisfy multiple conditions. |
MAXVISIBLE | Returns the largest value from the visible, non blank cells. |
MEDIANIFS | Returns the middle value from the cells that satisfy multiple conditions. |
MEDIANIFSVISIBLE | Returns the middle value from the visible, non blank cells that satisfy multiple conditions. |
MEDIANVISIBLE | Returns the middle value from the visible cells. |
MERGECELLS | Returns the text string that is a concatenation of several strings or values. |
MINAVISIBLE | Returns the smallest value from the visible, non blank cells (including logical values and text). |
MINBETWEEN | Returns the smallest value that is between a range. |
MINIFSVISIBLE | Returns the smallest value from the visible, non blank cells that satisfy multiple conditions. |
MINVISIBLE | Returns the smallest value from the visible, non blank cells. |
NETWORKDAYSMISC | Returns the number of days between two dates using a defined list of workdays. |
NEXTWEEKDAY | Returns the date of the next weekday. |
NONBLANKVALUES | Returns an array of all the non blank items in a range. |
NUMBERFORMATGET | Returns the number format that has been applied to a particular cell. |
NUMBERTOROMAN | Returns the text string converting a binary number to a roman numeral. |
ORDINAL | Returns a number with its corresponding ordinal abbreviation. |
PERCENTAGEIFS | Returns the percentage of values that satisfy multiple conditions. |
PREVIOUSWEEKDAY | Returns the date of the previous weekday. |
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. |
REMOVENUMBERS | Returns any numbers from a text string. |
REMOVESPACES | Returns a text string with any spaces removed. |
REMOVETEXT | Returns a text string with a substring removed. |
REVERSE | Returns the contents of a particular cell with all the characters reversed. |
ROWHEIGHT | Returns the row height of a particular cell. |
SCRAMBLE | Returns the contents of a particular cell with all the characters in a random order. |
SELECTONE | Returns a value at random from a range of cells. |
SHEETOFFSET | Returns the contents of a cell on a different worksheet. |
SPELLNUMBER | Returns the word equivalent for a numerical number. |
SPELLNUMBERREVERSE | Returns the number equivalent for a number written as text. |
SUMBETWEEN | Returns the sum of values that are between a range. |
SUMDIGITS | Returns the sum of the digits in a particular cell. |
SUMFORMAT | Returns the sum of values that have a particular cell color or font color. |
SUMIFSVISIBLE | Returns the sum of values from the visible, non blank cells that satisfy multiple conditions. |
SUMVISIBLE | Returns the sum of values from the visible, non blank cells. |
UNIQUEITEMS | Returns an array of all the unique items in a range. |
USERNAME | Returns the application's user name or the domain username. |
VLOOKUPINTERPOLATE | Returns an interpolated value if an exact match is not found. |
WEEKNUMBER | Returns the week number of a particular date. |
WORDCOUNT | Returns the number of words in a particular cell. |
WORDGET | Returns the nth element of a string that uses a separator character. |
WORKBOOKFILEEXTENSION | Returns the file extension of the active workbook. |
WORKBOOKFILENAME | Returns the file name of the active workbook. |
WORKBOOKPATH | Returns the folder path of the active workbook. |
WORKBOOKPATHFILENAME | Returns the folder path and file name of the active workbook. |
WORKDAY6 | Returns the serial number before or after a given number of days from a start date assuming a 6-day working week. |
WORKDAYSMISC | Returns the serial number before or after a given number of days from a start date using a defined list of workdays. |
WORKSHEETNAME | Returns the name of a worksheet in the active workbook given an index position. |
WORKSHEETSCOUNT | Returns the total number of sheets in the active workbook. |
ACRONYM Returns the first letter of each word. |
AGE Returns the age of a person given a birthday. |
ALLSHEETS Returns the min, max or sum of the identical cells across all worksheets. |
AVERAGEAVISIBLE Returns the average value from the visible, non blank cells in a range (including logical values and text). |
AVERAGEIFSVISIBLE Returns the average value from the visible, non blank cells that satisfy multiple conditions. |
AVERAGETOP Returns the average value from the cells with the top "x" values or percentage. |
AVERAGEVISIBLE Returns the average value from the visible, non blank cells. |
CELLTYPE Returns the type of value that is contained in a particular cell. |
COLUMNWIDTH Returns the column width of a particular cell. |
COMMENTGET Returns the comment associated with a particular cell. |
COMPUTERNAME Returns the full computer name. |
CONTAINS Returns whether a string is contained inside another string. |
COUNTAVISIBLE Returns the number of visible, non blank cells in a range (including logical values and text). |
COUNTBETWEEN Returns the number of cells that have a value that is between a range. |
COUNTFORMAT Returns the number of cells that have a particular cell color or font color. |
COUNTIFSVISIBLE Returns the number of visible, non blank cells that satisfy multiple conditions. |
COUNTNUMBEROFDAYS Returns the number of days in a particular month or year. |
COUNTSUBSTRING Returns the number of occurrences of a substring in a particular cell. |
COUNTTEXTCELLS Returns the number of cells that contain text. |
COUNTVISIBLE Returns the number of visible, non blank cells in a range. |
DATEUNITS Returns the number of units between two dates. |
DATESBEFORE1900 Returns the results of adding and subtracting dates before 1900 which are represented as text. |
DATEWHICHDAY Returns the date given a month, a week number and a day of the week. |
DAYSTOCHRISTMAS Returns the number of days to Christmas. |
EXCELDIR Returns the various folder locations that Excel uses including installation and startup. |
EXTRACTFILENAME Returns only the file name from a full file path. |
EXTRACTFILEPATH Returns only the file path from a full file path. |
EXTRACTFOLDERPATH Returns only the folder path from a full file path. |
EXTRACTNUMBERS Returns only the numbers from a text string. |
EXTRACTTEXT Returns only the text from a text string that contains other characters as well. |
FILEEXISTS Returns whether a particular file exists. |
FILEPROPERTIES Returns built-in or custom document properties from the active workbook. |
FINDMATCH Returns the position of an item in a list. |
FIRSTDATE Returns the date of the first day of a week, month or year. |
FIRSTWORD Returns the first word from a text string. |
FOLDEREXISTS Returns whether a particular folder exists. |
FORMATGET Returns a specific formatting attribute from a particular cell. |
HLOOKUPINTERPOLATE Returns an interpolated value if an exact match is not found. |
HYPERLINKGET Returns the hyperlink associated with a particular cell. |
IMAGEDISPLAY Returns an image in the top left corner of the active cell. |
INSERTSTRING Returns the text string with a substring inserted in the middle. |
INVERSE Returns the number divided into 1. |
ISBETWEEN Returns whether a particular cell value is between a range. |
ISBOLD Returns whether a particular cell has been formatted in bold. |
ISDATE Returns whether a date is the first (or last) of a week, month or year. |
ISFORMULA Returns whether a particular cell contains a formula. |
ISINTEGER Returns whether a particular cell contains an integer number. |
ISITALIC Returns whether a particular cell has been formatted in italic. |
ISLIKE Returns whether a particular cell contains a string that matches a certain pattern. |
ISLOCKED Returns whether a particular cell has been locked. |
ISLOWER Returns whether a particular cell has been formatted in lower case. |
ISMERGED Returns whether a particular cell has been merged. |
ISPRIME Returns whether a particular cell contains a prime number. |
ISPROPER Returns whether a particular cell has been formatted in proper case. |
ISUNDERLINE Returns whether a particular cell has been formatted in underline. |
ISUPPER Returns whether a particular cell has been formatted in upper case. |
ISWRAPPED Returns whether a particular cell has been formatted with text wrap. |
LASTDATE Returns the date of the last day of a week, month or year. |
LASTINCOLUMN Returns the last cell that contains data in a particular column. |
LASTINROW Returns the last cell that contains data in a particular row. |
LASTWORD Returns the last word from a text string. |
MAXAVISIBLE Returns the largest value from the visible, non blank cells (including logical values and text). |
MAXBETWEEN Returns the largest value that is between a range. |
MAXIFSVISIBLE Returns the largest value from the visible, non blank cells that satisfy multiple conditions. |
MAXVISIBLE Returns the largest value from the visible, non blank cells. |
MEDIANIFS Returns the middle value from the cells that satisfy multiple conditions. |
MEDIANIFSVISIBLE Returns the middle value from the visible, non blank cells that satisfy multiple conditions. |
MEDIANVISIBLE Returns the middle value from the visible cells. |
MERGECELLS Returns the text string that is a concatenation of several strings or values. |
MINAVISIBLE Returns the smallest value from the visible, non blank cells (including logical values and text). |
MINBETWEEN Returns the smallest value that is between a range. |
MINIFSVISIBLE Returns the smallest value from the visible, non blank cells that satisfy multiple conditions. |
MINVISIBLE Returns the smallest value from the visible, non blank cells. |
NETWORKDAYSMISC Returns the number of days between two dates using a defined list of workdays. |
NEXTWEEKDAY Returns the date of the next weekday. |
NONBLANKVALUES Returns an array of all the non blank items in a range. |
NUMBERFORMATGET Returns the number format that has been applied to a particular cell. |
NUMBERTOROMAN Returns the text string converting a binary number to a roman numeral. |
ORDINAL Returns a number with its corresponding ordinal abbreviation. |
PERCENTAGEIFS Returns the percentage of values that satisfy multiple conditions. |
PREVIOUSWEEKDAY Returns the date of the previous weekday. |
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. |
REMOVENUMBERS Returns any numbers from a text string. |
REMOVESPACES Returns a text string with any spaces removed. |
REMOVETEXT Returns a text string with a substring removed. |
REVERSE Returns the contents of a particular cell with all the characters reversed. |
ROWHEIGHT Returns the row height of a particular cell. |
SCRAMBLE Returns the contents of a particular cell with all the characters in a random order. |
SELECTONE Returns a value at random from a range of cells. |
SHEETOFFSET Returns the contents of a cell on a different worksheet. |
SPELLNUMBER Returns the word equivalent for a numerical number. |
SPELLNUMBERREVERSE Returns the number equivalent for a number written as text. |
SUMBETWEEN Returns the sum of values that are between a range. |
SUMDIGITS Returns the sum of the digits in a particular cell. |
SUMFORMAT Returns the sum of values that have a particular cell color or font color. |
SUMIFSVISIBLE Returns the sum of values from the visible, non blank cells that satisfy multiple conditions. |
SUMVISIBLE Returns the sum of values from the visible, non blank cells. |
UNIQUEITEMS Returns an array of all the unique items in a range. |
USERNAME Returns the application's user name or the domain username. |
VLOOKUPINTERPOLATE Returns an interpolated value if an exact match is not found. |
WEEKNUMBER Returns the week number of a particular date. |
WORDCOUNT Returns the number of words in a particular cell. |
WORDGET Returns the nth element of a string that uses a separator character. |
WORKBOOKFILEEXTENSION Returns the file extension of the active workbook. |
WORKBOOKFILENAME Returns the file name of the active workbook. |
WORKBOOKPATH Returns the folder path of the active workbook. |
WORKBOOKPATHFILENAME Returns the folder path and file name of the active workbook. |
WORKDAY6 Returns the serial number before or after a given number of days from a start date assuming a 6-day working week. |
WORKDAYSMISC Returns the serial number before or after a given number of days from a start date using a defined list of workdays. |
WORKSHEETNAME Returns the name of a worksheet in the active workbook given an index position. |
WORKSHEETSCOUNT Returns the total number of sheets in the active workbook. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext