Complete List

Function NameCategoryDescription
ACRONYMTextReturns the first letter of each word.
ADDNUMBERSSummingReturns the sum of a group of numbers.
AGEDate & TimeReturns the age of a person given a birthday.
AVERAGEVISIBLEIFSMathsReturns the average value in a list or array of numbers that satisfies multiple conditions.
COMMENTGETOtherReturns the comment associated with a particular cell.
COMPARECELLSOtherReturns a description of whether two ranges are identical or not.
CONTAINSTextReturns whether a string is contained inside another string.
CONVERTTIMEDate & TimeReturns the time converted to a decimal hours, minutes or seconds.
COUNTBETWEENCountingReturns the number of cells that have a value that is between a range.
COUNTFORMATCountingReturns the number of cells that have a particular cell color or font color.
COUNTHIDDENSHEETSInformationReturns the total number of hidden sheets in the active workbook.
COUNTSUBSTRINGCountingReturns the number of times a substring occurs in a larger text string.
COUNTVISIBLECountingReturns the number of visible, non blank cells in a range.
COUNTVISIBLEIFSCountingReturns the number of non blank cells that satisfies multiple conditions.
DATEDIFFERENCEDate & TimeReturns the difference between two dates.
DATESERIALDate & TimeReturns the date serial number given a date in text format.
DAYSTODate & TimeReturns the number of days (or other units) to a specific event.
DAYSTOCHRISTMASDate & TimeReturns the number of days to Christmas.
DUPLICATECELLSOtherReturns the cell addresses of all the items that appear more than once.
DUPLICATEVALUESOtherReturns the list of items that appear more than once.
EMAILVALIDOtherReturns whether a string is a valid email address.
EXTRACTFILENAMEOtherReturns only the file name from a full file path.
EXTRACTFOLDERPATHOtherReturns only the folder path from a full file path.
EXTRACTNUMBERSTextReturns only the numbers from a text string.
FILEEXISTSInformationReturns whether a particular file exists.
FORMATGETFormattingReturns a specific formatting attribute from a particular cell.
HYPERLINKGETOtherReturns the hyperlink associated with a particular cell.
ISBOLDInformationReturns whether a particular cell has been formatted in bold.
LASTINCOLUMNInformationReturns the last cell that contains data in a particular column.
LASTINROWInformationReturns the last cell that contains data in a particular row.
MAXVISIBLEIFSMathsReturns the largest value in a list or array of numbers that satisfies multiple conditions.
MERGECELLSOtherReturns the contents from all the cells and combines them to return a single string.
MINVISIBLEIFSMathsReturns the smallest value in a list or array of numbers that satisfies multiple conditions.
NUMBERFORMATGETFormattingReturns the number format that has been applied to a particular cell.
NUMBEROFDAYSDate & TimeReturns the number of days in a month and/or year.
PREVIOUSWEEKDAYDate & TimeReturns the date of the previous weekday.
RANDOMPASSWORDOtherReturns a specific number of random ASCII characters.
REMOVENUMBERSTextRemoves all numbers and spaces from a text string.
REVERSETextReturns the characters of a text string in reverse.
SAMPLEDATASample DataInserts sample data into the active worksheet.
SCRAMBLETextReturns the characters of a text string with all the characters in a random order.
SPELLNUMBERTextReturns the word equivalent for a numerical number.
SPELLNUMBERREVERSETextReturns the number equivalent for a number written as text.
SUMFORMATSummingReturns the sum of all the values that have been formatted with multiple attributes.
SUMVISIBLESummingReturns the sum of values from the visible, non blank cells.
SUMVISIBLEIFSSummingReturns the total value of the numbers that satisfies multiple conditions.
TIMENOWDate & TimeReturns the current time as a string (in the format "hh:mm:ss").
WORKBOOKFILENAMEInformationReturns the file name of the active workbook.
WORKBOOKPATHInformationReturns the folder path of the active workbook.
WORKBOOKPATHFILENAMEInformationReturns the folder path and file name of the active workbook.
WORKBOOKPROPERTIESInformationReturns a particular workbook property of the active workbook.
WORKSHEETNAMEInformationReturns the name of the worksheet in a given position.
Function Name
Category
Description
ACRONYM
Text
Returns the first letter of each word.
ADDNUMBERS
Summing
Returns the sum of a group of numbers.
AGE
Date & Time
Returns the age of a person given a birthday.
AVERAGEVISIBLEIFS
Maths
Returns the average value in a list or array of numbers that satisfies multiple conditions.
COMMENTGET
Other
Returns the comment associated with a particular cell.
COMPARECELLS
Other
Returns a description of whether two ranges are identical or not.
CONTAINS
Text
Returns whether a string is contained inside another string.
CONVERTTIME
Date & Time
Returns the time converted to a decimal hours, minutes or seconds.
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
Information
Returns the total number of hidden sheets in the active workbook.
COUNTSUBSTRING
Counting
Returns the number of times a substring occurs in a larger text string.
COUNTVISIBLE
Counting
Returns the number of visible, non blank cells in a range.
COUNTVISIBLEIFS
Counting
Returns the number of non blank cells that satisfies multiple conditions.
DATEDIFFERENCE
Date & Time
Returns the difference between two dates.
DATESERIAL
Date & Time
Returns the date serial number given a date in text format.
DAYSTO
Date & Time
Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS
Date & Time
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.
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.
FILEEXISTS
Information
Returns whether a particular file exists.
FORMATGET
Formatting
Returns a specific formatting attribute from a particular cell.
HYPERLINKGET
Other
Returns the hyperlink associated with a particular cell.
ISBOLD
Information
Returns whether a particular cell has been formatted in bold.
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.
MAXVISIBLEIFS
Maths
Returns the largest value in a list or array of numbers that satisfies multiple conditions.
MERGECELLS
Other
Returns the contents from all the cells and combines them to return a single string.
MINVISIBLEIFS
Maths
Returns the smallest value in a list or array of numbers that satisfies multiple conditions.
NUMBERFORMATGET
Formatting
Returns the number format that has been applied to a particular cell.
NUMBEROFDAYS
Date & Time
Returns the number of days in a month and/or year.
PREVIOUSWEEKDAY
Date & Time
Returns the date of the previous weekday.
RANDOMPASSWORD
Other
Returns a specific number of random ASCII characters.
REMOVENUMBERS
Text
Removes all numbers and spaces from a text string.
REVERSE
Text
Returns the characters of a text string in reverse.
SAMPLEDATA
Sample Data
Inserts sample data into the active worksheet.
SCRAMBLE
Text
Returns the characters of a text string with all the characters in a random order.
SPELLNUMBER
Text
Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE
Text
Returns the number equivalent for a number written as text.
SUMFORMAT
Summing
Returns the sum of all the values that have been formatted with multiple attributes.
SUMVISIBLE
Summing
Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS
Summing
Returns the total value of the numbers that satisfies multiple conditions.
TIMENOW
Date & Time
Returns the current time as a string (in the format "hh:mm:ss").
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.
WORKSHEETNAME
Information
Returns the name of the worksheet in a given position.

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