# Complete List

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. |

BUSDAYNEXT | Date & Time | Returns the date of the next business day. |

BUSDAYPREVIOUS | Date & Time | Returns the date of the previous business day. |

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. |

DAYSINAMONTH | Date & Time | Returns the number of days in a month and year. |

DAYSINAYEAR | Date & Time | Returns the number of days in a year. |

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. |

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. |

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. |

BUSDAYNEXTDate & TimeReturns the date of the next business day. |

BUSDAYPREVIOUSDate & TimeReturns the date of the previous business day. |

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. |

DAYSINAMONTHDate & TimeReturns the number of days in a month and year. |

DAYSINAYEARDate & TimeReturns the number of days in a year. |

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. |

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. |

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