User Defined Functions Complete List

Function Name	Category	Description
ACRONYM	Text	Returns the first letter of each word.
AGE	Dates	Returns the age of a person given a birthday.
ALLSHEETS	Other	Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE	Statistical	Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOP	Statistical	Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE	Statistical	Returns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFS	Statistical	Returns the average value from the visible, non blank cells that satisfy multiple conditions.
CELLTYPE	Information	Returns the type of value that is contained in a particular cell.
COLUMNWIDTH	Information	Returns the column width of a particular cell.
COMMENTGET	Other	Returns the comment associated with a particular cell.
COMPARECELLS	Other	Returns a description of whether two ranges are identical or not.
COMPUTERNAME	Information	Returns the full computer name.
CONVERTTIME	Dates	Returns the time converted to a decimal hours, minutes or seconds.
CONTAINS	Text	Returns whether a string is contained inside another string.
COUNTAVISIBLE	Counting	Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN	Counting	Returns the number of cells that have a value that is between a range.
COUNTFORMAT	Counting	Returns the number of cells that have a particular cell color or font color.
COUNTHIDDENSHEETS	Counting	Returns the number of hidden worksheets in the active workbook.
COUNTSHEETS	Counting	Returns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRING	Counting	Returns the number of occurrences of a substring in a particular cell.
COUNTTEXTCELLS	Counting	Returns the number of cells that contain text.
COUNTVISIBLE	Counting	Returns the number of visible, non blank cells in a range.
COUNTVISIBLEIFS	Counting	Returns the number of visible, non blank cells that satisfy multiple conditions.
DATEDIFFERENCE	Dates	Returns the number of days, months or years between two dates.
DATESBEFORE1900	Dates	Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATESERIAL	Dates	Returns the date serial number given a date in text format.
DATEWHICHDAY	Dates	Returns the date given a month, a week number and a day of the week.
DAYSTO	Dates	Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS	Dates	Returns the number of days to Christmas.
DUPLICATECELLS	Other	Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES	Other	Returns the list of items that appear more than once.
EMAILVALID	Other	Returns whether a string is a valid email address.
EXCELDIR	Information	Returns the various folder locations that Excel uses including installation and startup.
EXTRACTFILENAME	Other	Returns only the file name from a full file path.
EXTRACTFOLDERPATH	Other	Returns only the folder path from a full file path.
EXTRACTNUMBERS	Text	Returns only the numbers from a text string.
EXTRACTTEXT	Text	Returns only the text from a text string that contains other characters as well.
FILEEXISTS	Information	Returns whether a particular file exists.
FINDMATCH	Other	Returns the position of an item in a list.
FIRSTDATE	Dates	Returns the date of the first day of a week, month or year.
FIRSTWORD	Text	Returns the first word from a text string.
FOLDEREXISTS	Information	Returns whether a particular folder exists.
FORMATGET	Formatting	Returns a specific formatting attribute from a particular cell.
HLOOKUPINTERPOLATE	Other	Returns an interpolated value if an exact match is not found.
HYPERLINKGET	Other	Returns the hyperlink associated with a particular cell.
IMAGEDISPLAY	Other	Returns an image in the top left corner of the active cell.
INSERTSTRING	Other	Returns the text string with a substring inserted in the middle.
INVERSE	Other	Returns the number divided into 1.
ISBETWEEN	Information	Returns whether a particular cell value is between a range.
ISBOLD	Information	Returns whether a particular cell has been formatted in bold.
ISDATE	Dates	Returns whether a particular value is a valid date.
ISDATEFIRST	Dates	Returns whether a date is the first of a week, month or year.
ISDATELAST	Dates	Returns whether a date is the last of a week, month or year.
ISINTEGER	Information	Returns whether a particular cell contains an integer number.
ISITALIC	Information	Returns whether a particular cell has been formatted in italic.
ISLIKE	Text	Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED	Information	Returns whether a particular cell has been locked.
ISLOWER	Information	Returns whether a particular cell has been formatted in lower case.
ISMERGED	Information	Returns whether a particular cell has been merged.
ISPRIME	Information	Returns whether a particular cell contains a prime number.
ISPROPER	Information	Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE	Information	Returns whether a particular cell has been formatted in underline.
ISUPPER	Information	Returns whether a particular cell has been formatted in upper case.
ISWRAPPED	Information	Returns whether a particular cell has been formatted with text wrap.
LASTDATE	Dates	Returns the date of the last day of a week, month or year.
LASTINCOLUMN	Information	Returns the last cell that contains data in a particular column.
LASTINROW	Information	Returns the last cell that contains data in a particular row.
LASTWORD	Text	Returns the last word from a text string.
MAXAVISIBLE	Statistical	Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN	Statistical	Returns the largest value that is between a range.
MAXVISIBLE	Statistical	Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS	Statistical	Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MEDIANIFS	Statistical	Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE	Statistical	Returns the middle value from the visible cells.
MEDIANVISIBLEIFS	Statistical	Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MERGECELLS	Other	Returns the text string that is a concatenation of several strings or values.
MINAVISIBLE	Statistical	Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN	Statistical	Returns the smallest value that is between a range.
MINVISIBLE	Statistical	Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS	Statistical	Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
NETWORKDAYSMISC	Dates	Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY	Dates	Returns the date of the next weekday.
NONBLANKVALUES	Other	Returns an array of all the non blank items in a range.
NUMBERFORMATGET	Formatting	Returns the number format that has been applied to a particular cell.
NUMBEROFDAYS	Dates	Returns the number of days in a particular month or year.
NUMBERTOROMAN	Text	Returns the text string converting a binary number to a roman numeral.
ORDINAL	Text	Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS	Other	Returns the percentage of values that satisfy multiple conditions.
PREVIOUSWEEKDAY	Dates	Returns the date of the previous weekday.
RANDOMNUMBER	Other	Returns a random number between two intervals.
RANDOMPASSWORD	Other	Returns a specific number of random ASCII characters.
REMOVENUMBERS	Text	Returns any numbers from a text string.
REMOVESPACES	Text	Returns a text string with any spaces removed.
REMOVETEXT	Text	Returns a text string with a substring removed.
REVERSE	Text	Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT	Information	Returns the row height of a particular cell.
SCRAMBLE	Text	Returns the contents of a particular cell with all the characters in a random order.
SELECTONE	Other	Returns a value at random from a range of cells.
SHEETOFFSET	Other	Returns the contents of a cell on a different worksheet.
SPELLNUMBER	Text	Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE	Text	Returns the number equivalent for a number written as text.
SUMBETWEEN	Summing	Returns the sum of values that are between a range.
SUMDIGITS	Summing	Returns the sum of the digits in a particular cell.
SUMFORMAT	Summing	Returns the sum of values that have a particular cell color or font color.
SUMVISIBLE	Summing	Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS	Summing	Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
TIMENOW	Dates	Returns the current time as a string (in the format "hh:mm:ss").
USERNAME	Information	Returns the application's user name or the domain username.
VLOOKUPINTERPOLATE	Other	Returns an interpolated value if an exact match is not found.
WEEKNUMBER	Dates	Returns the week number of a particular date.
WORDCOUNT	Text	Returns the number of words in a particular cell.
WORDGET	Text	Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION	Information	Returns the file extension of the active workbook.
WORKBOOKFILENAME	Information	Returns the file name of the active workbook.
WORKBOOKPATH	Information	Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME	Information	Returns the folder path and file name of the active workbook.
WORKBOOKPROPERTIES	Information	Returns a particular workbook property of the active workbook.
WORKDAY6	Dates	Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC	Dates	Returns the serial number before or after a given number of days from a start date using a defined list of workdays.
WORKSHEETNAME	Information	Returns the name of a worksheet in the active workbook given an index position.

Function Name Category Description
ACRONYM Text Returns the first letter of each word.
AGE Dates Returns the age of a person given a birthday.
ALLSHEETS Other Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE Statistical Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOP Statistical Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE Statistical Returns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFS Statistical Returns the average value from the visible, non blank cells that satisfy multiple conditions.
CELLTYPE Information Returns the type of value that is contained in a particular cell.
COLUMNWIDTH Information Returns the column width of a particular cell.
COMMENTGET Other Returns the comment associated with a particular cell.
COMPARECELLS Other Returns a description of whether two ranges are identical or not.
COMPUTERNAME Information Returns the full computer name.
CONVERTTIME Dates Returns the time converted to a decimal hours, minutes or seconds.
CONTAINS Text Returns whether a string is contained inside another string.
COUNTAVISIBLE Counting Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN Counting Returns the number of cells that have a value that is between a range.
COUNTFORMAT Counting Returns the number of cells that have a particular cell color or font color.
COUNTHIDDENSHEETS Counting Returns the number of hidden worksheets in the active workbook.
COUNTSHEETS Counting Returns the total number of worksheets and chart sheets in the active workbook.
COUNTSUBSTRING Counting Returns the number of occurrences of a substring in a particular cell.
COUNTTEXTCELLS Counting Returns the number of cells that contain text.
COUNTVISIBLE Counting Returns the number of visible, non blank cells in a range.
COUNTVISIBLEIFS Counting Returns the number of visible, non blank cells that satisfy multiple conditions.
DATEDIFFERENCE Dates Returns the number of days, months or years between two dates.
DATESBEFORE1900 Dates Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATESERIAL Dates Returns the date serial number given a date in text format.
DATEWHICHDAY Dates Returns the date given a month, a week number and a day of the week.
DAYSTO Dates Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS Dates Returns the number of days to Christmas.
DUPLICATECELLS Other Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES Other Returns the list of items that appear more than once.
EMAILVALID Other Returns whether a string is a valid email address.
EXCELDIR Information Returns the various folder locations that Excel uses including installation and startup.
EXTRACTFILENAME Other Returns only the file name from a full file path.
EXTRACTFOLDERPATH Other Returns only the folder path from a full file path.
EXTRACTNUMBERS Text Returns only the numbers from a text string.
EXTRACTTEXT Text Returns only the text from a text string that contains other characters as well.
FILEEXISTS Information Returns whether a particular file exists.
FINDMATCH Other Returns the position of an item in a list.
FIRSTDATE Dates Returns the date of the first day of a week, month or year.
FIRSTWORD Text Returns the first word from a text string.
FOLDEREXISTS Information Returns whether a particular folder exists.
FORMATGET Formatting Returns a specific formatting attribute from a particular cell.
HLOOKUPINTERPOLATE Other Returns an interpolated value if an exact match is not found.
HYPERLINKGET Other Returns the hyperlink associated with a particular cell.
IMAGEDISPLAY Other Returns an image in the top left corner of the active cell.
INSERTSTRING Other Returns the text string with a substring inserted in the middle.
INVERSE Other Returns the number divided into 1.
ISBETWEEN Information Returns whether a particular cell value is between a range.
ISBOLD Information Returns whether a particular cell has been formatted in bold.
ISDATE Dates Returns whether a particular value is a valid date.
ISDATEFIRST Dates Returns whether a date is the first of a week, month or year.
ISDATELAST Dates Returns whether a date is the last of a week, month or year.
ISINTEGER Information Returns whether a particular cell contains an integer number.
ISITALIC Information Returns whether a particular cell has been formatted in italic.
ISLIKE Text Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED Information Returns whether a particular cell has been locked.
ISLOWER Information Returns whether a particular cell has been formatted in lower case.
ISMERGED Information Returns whether a particular cell has been merged.
ISPRIME Information Returns whether a particular cell contains a prime number.
ISPROPER Information Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE Information Returns whether a particular cell has been formatted in underline.
ISUPPER Information Returns whether a particular cell has been formatted in upper case.
ISWRAPPED Information Returns whether a particular cell has been formatted with text wrap.
LASTDATE Dates Returns the date of the last day of a week, month or year.
LASTINCOLUMN Information Returns the last cell that contains data in a particular column.
LASTINROW Information Returns the last cell that contains data in a particular row.
LASTWORD Text Returns the last word from a text string.
MAXAVISIBLE Statistical Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN Statistical Returns the largest value that is between a range.
MAXVISIBLE Statistical Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS Statistical Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MEDIANIFS Statistical Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE Statistical Returns the middle value from the visible cells.
MEDIANVISIBLEIFS Statistical Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MERGECELLS Other Returns the text string that is a concatenation of several strings or values.
MINAVISIBLE Statistical Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN Statistical Returns the smallest value that is between a range.
MINVISIBLE Statistical Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS Statistical Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
NETWORKDAYSMISC Dates Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY Dates Returns the date of the next weekday.
NONBLANKVALUES Other Returns an array of all the non blank items in a range.
NUMBERFORMATGET Formatting Returns the number format that has been applied to a particular cell.
NUMBEROFDAYS Dates Returns the number of days in a particular month or year.
NUMBERTOROMAN Text Returns the text string converting a binary number to a roman numeral.
ORDINAL Text Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS Other Returns the percentage of values that satisfy multiple conditions.
PREVIOUSWEEKDAY Dates Returns the date of the previous weekday.
RANDOMNUMBER Other Returns a random number between two intervals.
RANDOMPASSWORD Other Returns a specific number of random ASCII characters.
REMOVENUMBERS Text Returns any numbers from a text string.
REMOVESPACES Text Returns a text string with any spaces removed.
REMOVETEXT Text Returns a text string with a substring removed.
REVERSE Text Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT Information Returns the row height of a particular cell.
SCRAMBLE Text Returns the contents of a particular cell with all the characters in a random order.
SELECTONE Other Returns a value at random from a range of cells.
SHEETOFFSET Other Returns the contents of a cell on a different worksheet.
SPELLNUMBER Text Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE Text Returns the number equivalent for a number written as text.
SUMBETWEEN Summing Returns the sum of values that are between a range.
SUMDIGITS Summing Returns the sum of the digits in a particular cell.
SUMFORMAT Summing Returns the sum of values that have a particular cell color or font color.
SUMVISIBLE Summing Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS Summing Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
TIMENOW Dates Returns the current time as a string (in the format "hh:mm:ss").
USERNAME Information Returns the application's user name or the domain username.
VLOOKUPINTERPOLATE Other Returns an interpolated value if an exact match is not found.
WEEKNUMBER Dates Returns the week number of a particular date.
WORDCOUNT Text Returns the number of words in a particular cell.
WORDGET Text Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION Information Returns the file extension of the active workbook.
WORKBOOKFILENAME Information Returns the file name of the active workbook.
WORKBOOKPATH Information Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME Information Returns the folder path and file name of the active workbook.
WORKBOOKPROPERTIES Information Returns a particular workbook property of the active workbook.
WORKDAY6 Dates Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC Dates Returns the serial number before or after a given number of days from a start date using a defined list of workdays.
WORKSHEETNAME Information Returns the name of a worksheet in the active workbook given an index position.