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.

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