User Defined Functions

ACRONYMReturns the first letter of each word.
AGEReturns the age of a person given a birthday.
ALLSHEETSReturns the min, max or sum of the identical cells across all worksheets.
AVERAGEIFReturns the average value from the cells that satisfy one condition.
AVERAGEIFSVISIBLEReturns the average value from the visible, non blank cells that satisfy multiple conditions.
AVERAGEIFVISIBLEReturns the average value from the visible, non blank cells that satisfy one condition.
AVERAGETOPReturns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLEReturns the average value from the visible, non blank cells.
CELLTYPEReturns the type of value that is contained in a particular cell.
COLUMNWIDTHReturns the column width of a particular cell.
COMMENTGETReturns the comment associated with a particular cell.
COMPUTERNAMEReturns the full computer name.
CONTAINSReturns whether a string is contained inside another string.
COUNTAVISIBLEReturns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEENReturns the number of cells that have a value that is between a range.
COUNTFORMATReturns the number of cells that have a particular cell color or font color.
COUNTFORMAT_CELLCOLOR 
COUNTFORMAT_FONTBOLD 
COUNTFORMAT_FONTCOLOR 
COUNTIFSVISIBLEReturns the number of visible, non blank cells that satisfy multiple conditions.
COUNTIFVISIBLEReturns the number of visible, non blank cells that satisfy one condition.
COUNTNUMBEROFDAYSReturns the number of days in a particular month or year.
COUNTSUBSTRINGReturns the number of occurrences of a substring in a particular cell.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTVISIBLEReturns the number of visible, non blank cells in a range.
DATESBEFORE1900Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAYReturns the date given a month, a week number and a day of the week.
EXCELDIRReturns the various folder locations that Excel uses including installation and startup.
EXTRACTFILENAMEReturns only the file name from a full file path.
EXTRACTFILEPATHReturns only the file path from a full file path.
EXTRACTFOLDERPATHReturns only the folder path from a full file path.
EXTRACTNUMBERSReturns only the numbers from a text string.
EXTRACTTEXTReturns only the text from a text string that contains other characters as well.
FILEEXISTSReturns whether a particular file exists.
FILEPROPERTIESReturns built-in or custom document properties from the active workbook.
FINDMATCHReturns the position of an item in a list.
FIRSTDATEReturns the date of the first day of a week, month or year.
FIRSTWORD 
FOLDEREXISTSReturns whether a particular folder exists.
FORMATGETReturns a specific formatting attribute from a particular cell.
FORMULAGETReturns the formula from a particular cell.
HLOOKUPINTERPOLATEReturns an interpolated value if an exact match is not found.
HYPERLINKGETReturns the hyperlink associated with a particular cell.
IFERROR(Added in 2017) Returns a value or something else when it returns an error.
IMAGEDISPLAYReturns an image in the top left corner of the active cell.
INSERTSTRINGReturns the text string with a substring inserted in the middle.
INVERSEReturns the number divided into 1.
ISBETWEENReturns whether a particular cell value is between a range.
ISBOLDReturns whether a particular cell has been formatted in bold.
ISDATEReturns whether a date is the first (or last) of a week, month or year.
ISFORMULAReturns whether a particular cell contains a formula.
ISINTEGERReturns whether a particular cell contains an integer number.
ISITALICReturns whether a particular cell has been formatted in italic.
ISLIKEReturns whether a particular cell contains a string that matches a certain pattern.
ISLOCKEDReturns whether a particular cell has been locked.
ISLOWERReturns whether a particular cell has been formatted in lower case.
ISMERGEDReturns whether a particular cell has been merged.
ISPRIMEReturns whether a particular cell contains a prime number.
ISPROPERReturns whether a particular cell has been formatted in proper case.
ISUNDERLINEReturns whether a particular cell has been formatted in underline.
ISUPPERReturns whether a particular cell has been formatted in upper case.
ISWRAPPEDReturns whether a particular cell has been formatted with text wrap.
LASTDATEReturns the date of the last day of a week, month or year.
LASTINCOLUMNReturns the last cell that contains data in a particular column.
LASTINROWReturns the last cell that contains data in a particular row.
LASTWORDReturns the last word in a particular cell.
MAXBETWEENReturns the largest value that is between a range.
MAXIF(MAXIFS added in 2016 January) Returns the largest value from the cells that satisfy one condition.
MAXIFSVISIBLEReturns the largest value from the visible, non blank cells that satisfy multiple conditions.
MAXIFVISIBLEReturns the largest value from the visible, non blank cells that satisfy one condition.
MAXVISIBLEReturns the largest value from the visible, non blank cells.
MEDIANIFReturns the middle value from the cells that satisfy one condition.
MEDIANIFSReturns the middle value from the cells that satisfy multiple conditions.
MEDIANIFSVISIBLEReturns the middle value from the visible, non blank cells that satisfy multiple conditions.
MEDIANIFVISIBLEReturns the middle value from the visible, non blank cells that satisfy one condition.
MERGECELLSReturns the text string that is a concatenation of several strings or values.
MINBETWEENReturns the smallest value that is between a range.
MINIF(MINIFS added in 2016 January) Returns the smallest value from the cells that satisfy one condition.
MINIFSVISIBLEReturns the smallest value from the visible, non blank cells that satisfy multiple conditions.
MINIFVISIBLEReturns the smallest value from the visible, non blank cells that satisfy one condition.
MINVISIBLEReturns the smallest value from the visible, non blank cells.
NETWORKDAYSMISCReturns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAYReturns the date of the next weekday.
NONBLANKVALUESReturns an array of all the non blank items in a range.
NUMBERFORMATGETReturns the number format that has been applied to a particular cell.
NUMBERTOROMANReturns the text string converting a binary number to a roman numeral.
ORDINALReturns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFReturns the percentage of values that satisfy one condition.
PERCENTAGEIFSReturns the percentage of values that satisfy multiple conditions.
PREVIOUSWEEKDAYReturns the date of the previous weekday.
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 contents of a particular cell with all the characters reversed.
ROWHEIGHTReturns the row height of a particular cell.
SCRAMBLEReturns the contents of a particular cell with all the characters in a random order.
SELECTONEReturns a value at random from a range of cells.
SHEETOFFSETReturns the contents of a cell on a different worksheet.
SPELLNUMBERReturns the word equivalent for a numerical number.
SPELLNUMBERREVERSEReturns the number equivalent for a number written as text.
SUMBETWEENReturns the sum of values that are between a range.
SUMDIGITSReturns the sum of the digits in a particular cell.
SUMFORMATReturns the sum of values that have a particular cell color or font color.
SUMFORMAT_CELLCOLOR 
SUMFORMAT_FONTCOLOR 
SUMIFSVISIBLEReturns the sum of values from the visible, non blank cells that satisfy multiple conditions.
SUMIFVISIBLEReturns the sum of values from the visible, non blank cells that satisfy one condition.
SUMVISIBLEReturns the sum of values from the visible, non blank cells.
UNIQUEITEMSReturns an array of all the unique items in a range.
USERNAMEReturns the application's user name or the domain username.
VLOOKUPINTERPOLATEReturns an interpolated value if an exact match is not found.
WEEKNUMBERReturns the week number of a particular date.
WORDCOUNTReturns the number of words in a particular cell.
WORDGET 
WORKBOOKFILEEXTENSIONReturns the file extension of the active workbook.
WORKBOOKFILENAMEReturns the file name of the active workbook.
WORKBOOKPATHReturns the folder path of the active workbook.
WORKBOOKPATHFILENAMEReturns the folder path and file name of the active workbook.
WORKDAY6Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISCReturns the serial number before or after a given number of days from a start date using a defined list of workdays.
WORKSHEETNAMEReturns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNTReturns 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.
AVERAGEIF
Returns the average value from the cells that satisfy one condition.
AVERAGEIFSVISIBLE
Returns the average value from the visible, non blank cells that satisfy multiple conditions.
AVERAGEIFVISIBLE
Returns the average value from the visible, non blank cells that satisfy one condition.
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.
COUNTFORMAT_CELLCOLOR
COUNTFORMAT_FONTBOLD
COUNTFORMAT_FONTCOLOR
COUNTIFSVISIBLE
Returns the number of visible, non blank cells that satisfy multiple conditions.
COUNTIFVISIBLE
Returns the number of visible, non blank cells that satisfy one condition.
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.
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.
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
FOLDEREXISTS
Returns whether a particular folder exists.
FORMATGET
Returns a specific formatting attribute from a particular cell.
FORMULAGET
Returns the formula 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.
IFERROR
(Added in 2017) Returns a value or something else when it returns an error.
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 in a particular cell.
MAXBETWEEN
Returns the largest value that is between a range.
MAXIF
(MAXIFS added in 2016 January) Returns the largest value from the cells that satisfy one condition.
MAXIFSVISIBLE
Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MAXIFVISIBLE
Returns the largest value from the visible, non blank cells that satisfy one condition.
MAXVISIBLE
Returns the largest value from the visible, non blank cells.
MEDIANIF
Returns the middle value from the cells that satisfy one condition.
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.
MEDIANIFVISIBLE
Returns the middle value from the visible, non blank cells that satisfy one condition.
MERGECELLS
Returns the text string that is a concatenation of several strings or values.
MINBETWEEN
Returns the smallest value that is between a range.
MINIF
(MINIFS added in 2016 January) Returns the smallest value from the cells that satisfy one condition.
MINIFSVISIBLE
Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
MINIFVISIBLE
Returns the smallest value from the visible, non blank cells that satisfy one condition.
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.
PERCENTAGEIF
Returns the percentage of values that satisfy one condition.
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.
REMOVENUMBERS
Returns any numbers from a text string.
REMOVESPACES
Returns a text string with any spaces 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.
SUMFORMAT_CELLCOLOR
SUMFORMAT_FONTCOLOR
SUMIFSVISIBLE
Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
SUMIFVISIBLE
Returns the sum of values from the visible, non blank cells that satisfy one condition.
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
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.

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