Function Migration
Our list of initial functions has been taken from the following add-ins: ASAP Utilities, Power Utility Pack, KuTools, OzGrid and MoreFunc.
We are slowly adding to this list, so please let us know if there are any functions you would like us to include.
ASAP Utilities Functions
link - asap-utilities.com/ asap-utilities-excel-tools-tip.php?tip=259
Library Function | Description |
ASAPCELLCOLORINDEX | Returns the color index number of the cell. FORMATGET |
ASAPCOUNTBYCELLCOLOR | Counts the number of cells in the given range that have a certain fill color. COUNTFORMAT |
ASAPCOUNTBYFONTCOLOR | Counts the number of cells in the given range that have a certain font color. COUNTFORMAT |
ASAPCOUNTCHAR | Counts the number of times a character occurs in a text. COUNTSUBSTRING |
ASAPCOUNTSHADES | Counts the number of colored cells in your range. COUNTFORMAT |
ASAPEXTRACTFILENAME | Returns the file name from a full path and filename. EXTRACTFILENAME |
ASAPEXTRACTFOLDERNAME | Returns the folder name from a combined filepath and filename. EXTRACTFOLDERPATH |
ASAPEXTRACTNUMBERS | Returns the numbers from a text string. EXTRACTNUMBERS |
ASAPFILENAME | Returns the name of your workbook. WORKBOOKFILENAME |
ASAPFILEPATH | Returns the filepath (the folder) where your workbook is stored. WORKBOOKPATH |
ASAPFILEPROPERTIES | Returns the value of one of the built-in document properties for the current workbook. WORKBOOKPROPERTIES |
ASAPFONTCOLORINDEX | Returns the color index number of the font of a cell. FORMATGET |
ASAPFULLFILENAME | Returns the full filename of your workbook. WORKBOOKPATHFILENAME |
ASAPGETCOMMENT | Returns the text from the comment a cell. COMMENTGET |
ASAPGETDOMAIN | Returns the (sub)domain from a given hyperlink (website address/url). HYPERLINKGET |
ASAPGETFONTNAME | Returns the name of the font in a cell. FORMATGET |
ASAPGETFONTSIZE | Returns the font size of a cell. FORMATGET |
ASAPGETFORMULA | FORMULATEXT added in 2013 to the Lookup & Reference category. Returns the formula from a particular cell. |
ASAPGETFORMULAINT | Returns the formula of a cell in the "international" notation. |
ASAPGETHYPERLINK | Returns the hyperlink from a cell. HYPERLINKGET |
ASAPGETNUMBERFORMAT | Returns the number format of a cell. NUMBERFORMATGET |
ASAPISBOLD | Returns TRUE if the cell is bold or FALSE if it isn't. ISBOLD |
ASAPISFORMULA | ISFORMULA added in 2013 to the Information category Returns TRUE if the cell has a formula or FALSE if it doesn't. |
ASAPLOADIMAGE | Inserts the specified image as an object and puts it at the left-top of your cell. IMAGEDISPLAY |
ASAPMERGECELLS | Joins several text strings into one text string. MERGECELLS |
ASAPRANDOMPASSWORD | Returns a random string that can be used as a password. RANDOMPASSWORD |
ASAPSHEETNAME | Returns the name of the worksheet this formula is used on. WORKSHEETNAME |
ASAPSPELLNUMBER | Returns a spelled-out number or amount. SPELLNUMBER |
ASAPSTRIPNUMBERS | Removes all numbers from a text string and removes all spaces at the beginning and end of the result. REMOVENUMBERS |
ASAPSUMBYCELLCOLOR | Adds the cells that have a certain fill color. SUMFORMAT |
ASAPSUMBYFONTCOLOR | Adds the cells that have a certain font color. SUMFORMAT |
Library Function Description |
ASAPCELLCOLORINDEX Returns the color index number of the cell. FORMATGET |
ASAPCOUNTBYCELLCOLOR Counts the number of cells in the given range that have a certain fill color. COUNTFORMAT |
ASAPCOUNTBYFONTCOLOR Counts the number of cells in the given range that have a certain font color. COUNTFORMAT |
ASAPCOUNTCHAR Counts the number of times a character occurs in a text. COUNTSUBSTRING |
ASAPCOUNTSHADES Counts the number of colored cells in your range. COUNTFORMAT |
ASAPEXTRACTFILENAME Returns the file name from a full path and filename. EXTRACTFILENAME |
ASAPEXTRACTFOLDERNAME Returns the folder name from a combined filepath and filename. EXTRACTFOLDERPATH |
ASAPEXTRACTNUMBERS Returns the numbers from a text string. EXTRACTNUMBERS |
ASAPFILENAME Returns the name of your workbook. WORKBOOKFILENAME |
ASAPFILEPATH Returns the filepath (the folder) where your workbook is stored. WORKBOOKPATH |
ASAPFILEPROPERTIES Returns the value of one of the built-in document properties for the current workbook. WORKBOOKPROPERTIES |
ASAPFONTCOLORINDEX Returns the color index number of the font of a cell. FORMATGET |
ASAPFULLFILENAME Returns the full filename of your workbook. WORKBOOKPATHFILENAME |
ASAPGETCOMMENT Returns the text from the comment a cell. COMMENTGET |
ASAPGETDOMAIN Returns the (sub)domain from a given hyperlink (website address/url). HYPERLINKGET |
ASAPGETFONTNAME Returns the name of the font in a cell. FORMATGET |
ASAPGETFONTSIZE Returns the font size of a cell. FORMATGET |
ASAPGETFORMULA FORMULATEXT added in 2013 to the Lookup & Reference category. Returns the formula from a particular cell. |
ASAPGETFORMULAINT Returns the formula of a cell in the "international" notation. |
ASAPGETHYPERLINK Returns the hyperlink from a cell. HYPERLINKGET |
ASAPGETNUMBERFORMAT Returns the number format of a cell. NUMBERFORMATGET |
ASAPISBOLD Returns TRUE if the cell is bold or FALSE if it isn't. ISBOLD |
ASAPISFORMULA ISFORMULA added in 2013 to the Information category Returns TRUE if the cell has a formula or FALSE if it doesn't. |
ASAPLOADIMAGE Inserts the specified image as an object and puts it at the left-top of your cell. IMAGEDISPLAY |
ASAPMERGECELLS Joins several text strings into one text string. MERGECELLS |
ASAPRANDOMPASSWORD Returns a random string that can be used as a password. RANDOMPASSWORD |
ASAPSHEETNAME Returns the name of the worksheet this formula is used on. WORKSHEETNAME |
ASAPSPELLNUMBER Returns a spelled-out number or amount. SPELLNUMBER |
ASAPSTRIPNUMBERS Removes all numbers from a text string and removes all spaces at the beginning and end of the result. REMOVENUMBERS |
ASAPSUMBYCELLCOLOR Adds the cells that have a certain fill color. SUMFORMAT |
ASAPSUMBYFONTCOLOR Adds the cells that have a certain font color. SUMFORMAT |
KuTools Functions
Link - extendoffice.com/ product/kutools-for-excel/ product-tutorials.html
Library Function | Description |
AVERAGEVISIBLE | Average Visible cells: Easily average visible cells, rows, or columns AVERAGEVISIBLE |
COUNTBYCELLCOLOR | Count by cell color: Count number of cells by a certain fill color COUNTFORMAT |
COUNTBYFONTBOLD | Count by font bold: Easily count the number of only bold cells in a range COUNTFORMAT |
COUNTBYFONTCOLOR | Count by font color: Count number of cells by a certain font color COUNTFORMAT |
COUNTCHAR | Count characters: Quickly count the occurrences of a character in a string COUNTSUBSTRING |
COUNTSHADES | Count shades: Counting numbers of cells which have been filled with color COUNTFORMAT |
COUNTVISIBLE | Count Visible Cells: Easily count visible cells, rows, or columns only COUNTVISIBLE |
EXTRACTNUMBERS | Extract Numbers: Extract numbers from mixed text string with the function EXTRACTNUMBERS |
REVERSETEXT | Reverse Text: Easily reverse order of characters in a cell with functions REVERSE |
SUMBYCELLCOLOR | Sum by cell color: Sum cells by a certain fill color SUMFORMAT |
SUMBYFONTBOLD | Sum by font bold: Quickly sum bold values / numbers only SUMFORMAT |
SUMBYFONTCOLOR | Sum by font color: Sum cells by a certain font color SUMFORMAT |
SUMVISIBLE | Sum Visible Cells: Easily sum visible cells, rows, or columns only SUMVISIBLE |
TIME2HOURS | Convert "hh:mm:ss" formatting time or text to decimal hours CONVERTTIME |
TIME2MINUTES | Convert "hh:mm:ss" formatting time or text to decimal minutes CONVERTTIME |
TIME2SECONDS | Convert "hh:mm:ss" formatting time or text to decimal seconds CONVERTTIME |
Library Function Description |
AVERAGEVISIBLE Average Visible cells: Easily average visible cells, rows, or columns AVERAGEVISIBLE |
COUNTBYCELLCOLOR Count by cell color: Count number of cells by a certain fill color COUNTFORMAT |
COUNTBYFONTBOLD Count by font bold: Easily count the number of only bold cells in a range COUNTFORMAT |
COUNTBYFONTCOLOR Count by font color: Count number of cells by a certain font color COUNTFORMAT |
COUNTCHAR Count characters: Quickly count the occurrences of a character in a string COUNTSUBSTRING |
COUNTSHADES Count shades: Counting numbers of cells which have been filled with color COUNTFORMAT |
COUNTVISIBLE Count Visible Cells: Easily count visible cells, rows, or columns only COUNTVISIBLE |
EXTRACTNUMBERS Extract Numbers: Extract numbers from mixed text string with the function EXTRACTNUMBERS |
REVERSETEXT Reverse Text: Easily reverse order of characters in a cell with functions REVERSE |
SUMBYCELLCOLOR Sum by cell color: Sum cells by a certain fill color SUMFORMAT |
SUMBYFONTBOLD Sum by font bold: Quickly sum bold values / numbers only SUMFORMAT |
SUMBYFONTCOLOR Sum by font color: Sum cells by a certain font color SUMFORMAT |
SUMVISIBLE Sum Visible Cells: Easily sum visible cells, rows, or columns only SUMVISIBLE |
TIME2HOURS Convert "hh:mm:ss" formatting time or text to decimal hours CONVERTTIME |
TIME2MINUTES Convert "hh:mm:ss" formatting time or text to decimal minutes CONVERTTIME |
TIME2SECONDS Convert "hh:mm:ss" formatting time or text to decimal seconds CONVERTTIME |
Power User Software
link - https://support.powerusersoftware.com/support/solutions/articles/80001023454-advanced-excel-functions
Library Function | Description |
CAGR | Returns the Compound Annual Growth Rate between 2 values for a given number of years. |
Concatenate_Range | Returns the concatenation of all cells within the defined range. |
CountColor | Returns the number of cells in the selected range that have the same fill color as the reference cell. |
CountUnique | Returns the number of unique values in the reference range. |
CountVisible | Returns the number of visible cells in the reference range. |
CountWords | Returns the number or words in a range that contains text. |
HasFormulas | Checks if the reference cell has formulas. |
Hlookup_Max | Returns the maximum value of all results that match lookup value. |
Hlookup_Min | Returns the minimum value of all results that match lookup value. |
IsMerged | Checks if the reference cell is merged with other cells. |
LastCell | Returns the value of the last cell (bottom right) in the defined sheet |
LastCellAddress | Returns the address of the last cell (bottom right) in the defined sheet |
LastColumnNumber | Returns the number of the last column (bottom right) in the defined sheet |
LastRowNumber | Returns the number of the last row (bottom right) in the defined sheet |
Percent_Change | Returns the percentage that changes one value into another. |
RangeExists | Checks if a named range exists in the defined sheet. |
RMS | Returns the Root Mean Square of a set of data. |
ShapeExists | Checks if a named shape exists in the defined sheet. |
SheetExists | Checks if a worksheet name exists in the active workbook. |
SheetName | Returns the name of the sheet that contains the reference cell. |
SlicerItems | Returns the list of items selected in the defined slicer. |
SumColor | Returns the sum of cells in the selected range that have the same fill color as the reference cell. |
SumFromAllSheets | Returns the sum of the values in the reference cell for all sheets in the active workbook. |
UsedRange | Returns the address of the range that is being used in the defined sheet. |
Vlookup_Max | Returns the maximum value of all results that match lookup value. |
Vlookup_Min | Returns the minimum value of all results that match lookup value. |
Weighted_Average | Returns the average of values in a column weighted by the values in another column. |
Word_n | Returns the n-th word from a text. WORDGET |
Library Function Description |
CAGR Returns the Compound Annual Growth Rate between 2 values for a given number of years. |
Concatenate_Range Returns the concatenation of all cells within the defined range. |
CountColor Returns the number of cells in the selected range that have the same fill color as the reference cell. |
CountUnique Returns the number of unique values in the reference range. |
CountVisible Returns the number of visible cells in the reference range. |
CountWords Returns the number or words in a range that contains text. |
HasFormulas Checks if the reference cell has formulas. |
Hlookup_Max Returns the maximum value of all results that match lookup value. |
Hlookup_Min Returns the minimum value of all results that match lookup value. |
IsMerged Checks if the reference cell is merged with other cells. |
LastCell Returns the value of the last cell (bottom right) in the defined sheet |
LastCellAddress Returns the address of the last cell (bottom right) in the defined sheet |
LastColumnNumber Returns the number of the last column (bottom right) in the defined sheet |
LastRowNumber Returns the number of the last row (bottom right) in the defined sheet |
Percent_Change Returns the percentage that changes one value into another. |
RangeExists Checks if a named range exists in the defined sheet. |
RMS Returns the Root Mean Square of a set of data. |
ShapeExists Checks if a named shape exists in the defined sheet. |
SheetExists Checks if a worksheet name exists in the active workbook. |
SheetName Returns the name of the sheet that contains the reference cell. |
SlicerItems Returns the list of items selected in the defined slicer. |
SumColor Returns the sum of cells in the selected range that have the same fill color as the reference cell. |
SumFromAllSheets Returns the sum of the values in the reference cell for all sheets in the active workbook. |
UsedRange Returns the address of the range that is being used in the defined sheet. |
Vlookup_Max Returns the maximum value of all results that match lookup value. |
Vlookup_Min Returns the minimum value of all results that match lookup value. |
Weighted_Average Returns the average of values in a column weighted by the values in another column. |
Word_n Returns the n-th word from a text. WORDGET |
Professor Excel
link - professor-excel.com/ features-of-professor-excel-tools-in-detail/
Library Function | Description |
PROFEXAuthor | |
PROFEXBackgroundColor | |
PROFEXCellFormatCodeFunction | |
PROFEXColumn | returns the column letter |
PROFEXCommentAuthorName | returns the name of the person who added the initial comment |
PROFEXDateCreated | |
PROFEXDateLastSaved | |
PROFEXFileSize | |
PROFEXFolderPath | |
PROFEXFontColor | |
PROFEXHasStrikethrough | |
PROFEXHyperlinkAddress | |
PROFEXIndentLevel | |
PROFEXIsVisible | |
PROFEXLastSavedBy | |
PROFEXMaxIf | |
PROFEXMinIf | |
PROFEXNoteText | |
PROFEXNumberOfHiddenWorksheets | |
PROFEXNumberOfWorksheets | built-in functions SHEETS |
PROFEXReply | returns the text of a reply comment |
PROFEXReplyAuthorName | returns the name of the person who added the nth comment |
PROFEXSheetName | |
PROFEXText | returns the text of a threaded comment |
PROFEXWeekdayName | |
PROFEXWorkbookPath |
Library Function Description |
PROFEXAuthor |
PROFEXBackgroundColor |
PROFEXCellFormatCodeFunction |
PROFEXColumn returns the column letter |
PROFEXCommentAuthorName returns the name of the person who added the initial comment |
PROFEXDateCreated |
PROFEXDateLastSaved |
PROFEXFileSize |
PROFEXFolderPath |
PROFEXFontColor |
PROFEXHasStrikethrough |
PROFEXHyperlinkAddress |
PROFEXIndentLevel |
PROFEXIsVisible |
PROFEXLastSavedBy |
PROFEXMaxIf |
PROFEXMinIf |
PROFEXNoteText |
PROFEXNumberOfHiddenWorksheets |
PROFEXNumberOfWorksheets built-in functions SHEETS |
PROFEXReply returns the text of a reply comment |
PROFEXReplyAuthorName returns the name of the person who added the nth comment |
PROFEXSheetName |
PROFEXText returns the text of a threaded comment |
PROFEXWeekdayName |
PROFEXWorkbookPath |
Power Utility Pack Functions
Library Function | Description |
CellColor | FORMATGET |
CellHasFormula | ISFORMULA added in Excel 2013 to the Information category. Returns TRUE if the cell has a formula or FALSE if it doesn't. |
CellType | CELLTYPE |
Char2 | UNICODE added in Excel 2013. |
Code2 | UNICHAR added in Excel 2013 |
Contains | CONTAINS |
CountAVisible | COUNTAVISIBLE |
CountBetween | Counts the number of values in a range that fall between two values. COUNTBETWEEN |
CreditCard | |
DaysInMonth | Returns the number of days in a month. DAYSINAMONTH |
DollorText | Returns its numeric argument, spelled out as dollars and cents text. SPELLNUMBER |
ExcelDir | EXCELDIR |
ExtractElement | Returns the nth element of a string that uses a separator character. WORDGET |
FileExists | FILEEXISTS |
FileName | WORKBOOKFILENAME |
FontColor | FORMATGET |
HInterpolate | HLOOKUPINTERPOLATE |
InsertString | INSERTSTRING |
IsLike | ISLIKE |
LastInColumn | LASTINCOLUMN |
LastInRow | LASTINROW |
MaxAllSheets | Returns the maximum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MAX |
MinAllSheets | Returns the minimum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MIN |
MonthWeek | Returns the calendar week for a date serial number WEEKNUMBER |
NumberFormat | NUMBERFORMATGET |
ParseName | Splits a string that contains a name into its component parts: first name, middle name, and last name |
RemoveSpaces | REMOVESPACES |
SayIt | |
Scramble | SCRAMBLE |
SelectOne | SELECTONE |
SheetCount | SHEETS added in Excel 2013. |
SheetName | WORKSHEETNAME |
SheetOffset | SHEETOFFSET |
StaticRand | RANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. RANDOMNUMBER |
SumAllSheets | Returns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS |
SumVisible | Similar to Excel's SUM function, but it returns the SUM of just the visible cells. This function is well-suited for use with AutoFiltering and Outlining. SUMVISIBLE |
TimeXX | Returns a string that represents a time, displayed as hh:mm:ss:xx, where xx is hundredths of a second (or another unit).. |
TimeXX_Add | Returns a string that represents the sum of two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TimeXX_Subtract | Returns a string that represents the difference between two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TimeXX_Sum | Returns a string that represents the sum TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TopAverage | Returns the average of the top n values in a list. AVERAGETOP |
UniqueItems | UNIQUE added in 2021. |
User | USERNAME |
VInterpolate | VLOOKUPINTERPOLATE |
WhichDay | Returns a date that corresponds to a specified day in a month. For example, the date of the first Friday in January for a given year. WHICHDAY |
XDate | DATESBEFORE1900 |
XDate_Add | DATESBEFORE1900 |
XDate_Day | DATESBEFORE1900 |
XDate_Dif | DATESBEFORE1900 |
XDate_Dow | DATESBEFORE1900 |
XDATE_Month | DATESBEFORE1900 |
XDate_Year | DATESBEFORE1900 |
XDate_YearDif | DATESBEFORE1900 |
Library Function Description |
CellColor FORMATGET |
CellHasFormula ISFORMULA added in Excel 2013 to the Information category. Returns TRUE if the cell has a formula or FALSE if it doesn't. |
CellType CELLTYPE |
Char2 UNICODE added in Excel 2013. |
Code2 UNICHAR added in Excel 2013 |
Contains CONTAINS |
CountAVisible COUNTAVISIBLE |
CountBetween Counts the number of values in a range that fall between two values. COUNTBETWEEN |
CreditCard |
DaysInMonth Returns the number of days in a month. DAYSINAMONTH |
DollorText Returns its numeric argument, spelled out as dollars and cents text. SPELLNUMBER |
ExcelDir EXCELDIR |
ExtractElement Returns the nth element of a string that uses a separator character. WORDGET |
FileExists FILEEXISTS |
FileName WORKBOOKFILENAME |
FontColor FORMATGET |
HInterpolate HLOOKUPINTERPOLATE |
InsertString INSERTSTRING |
IsLike ISLIKE |
LastInColumn LASTINCOLUMN |
LastInRow LASTINROW |
MaxAllSheets Returns the maximum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MAX |
MinAllSheets Returns the minimum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MIN |
MonthWeek Returns the calendar week for a date serial number WEEKNUMBER |
NumberFormat NUMBERFORMATGET |
ParseName Splits a string that contains a name into its component parts: first name, middle name, and last name |
RemoveSpaces REMOVESPACES |
SayIt |
Scramble SCRAMBLE |
SelectOne SELECTONE |
SheetCount SHEETS added in Excel 2013. |
SheetName WORKSHEETNAME |
SheetOffset SHEETOFFSET |
StaticRand RANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. RANDOMNUMBER |
SumAllSheets Returns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS |
SumVisible Similar to Excel's SUM function, but it returns the SUM of just the visible cells. This function is well-suited for use with AutoFiltering and Outlining. SUMVISIBLE |
TimeXX Returns a string that represents a time, displayed as hh:mm:ss:xx, where xx is hundredths of a second (or another unit).. |
TimeXX_Add Returns a string that represents the sum of two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TimeXX_Subtract Returns a string that represents the difference between two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TimeXX_Sum Returns a string that represents the sum TIMEXX time strings. The result is displayed as hh:mm:ss:xx. |
TopAverage Returns the average of the top n values in a list. AVERAGETOP |
UniqueItems UNIQUE added in 2021. |
User USERNAME |
VInterpolate VLOOKUPINTERPOLATE |
WhichDay Returns a date that corresponds to a specified day in a month. For example, the date of the first Friday in January for a given year. WHICHDAY |
XDate DATESBEFORE1900 |
XDate_Add DATESBEFORE1900 |
XDate_Day DATESBEFORE1900 |
XDate_Dif DATESBEFORE1900 |
XDate_Dow DATESBEFORE1900 |
XDATE_Month DATESBEFORE1900 |
XDate_Year DATESBEFORE1900 |
XDate_YearDif DATESBEFORE1900 |
OzGrid Functions
Library Function | Description |
AutoFilter_Criteria | |
CalculationMode | |
CalculationState | |
CellColor | FORMATGET* |
ColorRank | FORMATGET* |
ConvertCurrencyToEnglish | |
Count_Once | |
CountWords | WORDCOUNT |
FindNth | |
Five_Con_VLookup | |
Four_Con_VLookup | |
Get_Word | WORDNO |
GetAddress | HYPERLINKGET* |
GetCommentText | COMMENTGET* |
GetFilename | WORKBOOKFILENAME* |
GetMaxBetween | Returns the largest value that is between a range. MAXBETWEEN |
HowManyDaysInMonth | |
IsFormula | ISFORMULA added in Excel 2013 to the Information category. Returns TRUE if the cell has a formula or FALSE if it doesn't. |
LastDayOfMonth | LASTDATE_INTHISMONTH |
Lookup_Occurrence | |
MyFullName | WORKBOOKPATHFILENAME* |
MyName | Returns the application's user name or the domain username. USERNAME |
NthDayOfMonth | |
OzGridLookup | |
RandLotto | RANDOMNUMBER |
ReturnLastWord | WORDNO-LAST |
ReverseCell | Returns the contents of a particular cell with all the characters reversed. REVERSE |
SheetName | WORKSHEETNAME* |
SpellNumber | SPELLNUMBER* |
SumEveryNth | |
Three_Con_VLookup | |
Two_Con_VLookup | |
VLookAllSheets | VLOOKUPALL |
WorkbookExists | FILEEXISTS* |
Library Function Description |
AutoFilter_Criteria |
CalculationMode |
CalculationState |
CellColor FORMATGET* |
ColorRank FORMATGET* |
ConvertCurrencyToEnglish |
Count_Once |
CountWords WORDCOUNT |
FindNth |
Five_Con_VLookup |
Four_Con_VLookup |
Get_Word WORDNO |
GetAddress HYPERLINKGET* |
GetCommentText COMMENTGET* |
GetFilename WORKBOOKFILENAME* |
GetMaxBetween Returns the largest value that is between a range. MAXBETWEEN |
HowManyDaysInMonth |
IsFormula ISFORMULA added in Excel 2013 to the Information category. Returns TRUE if the cell has a formula or FALSE if it doesn't. |
LastDayOfMonth LASTDATE_INTHISMONTH |
Lookup_Occurrence |
MyFullName WORKBOOKPATHFILENAME* |
MyName Returns the application's user name or the domain username. USERNAME |
NthDayOfMonth |
OzGridLookup |
RandLotto RANDOMNUMBER |
ReturnLastWord WORDNO-LAST |
ReverseCell Returns the contents of a particular cell with all the characters reversed. REVERSE |
SheetName WORKSHEETNAME* |
SpellNumber SPELLNUMBER* |
SumEveryNth |
Three_Con_VLookup |
Two_Con_VLookup |
VLookAllSheets VLOOKUPALL |
WorkbookExists FILEEXISTS* |
MoreFunc Functions
Library Function | Description |
ANSI128 | Strips the accents from a string |
ARRAY.FILTER | Returns only the visible cells of a range (in an array) |
ARRAY.JOIN | Joins various items (ranges, unions, strings, numbers...) in a single array |
CHBASE | Converts a value from a base into another base |
COUNTDIFF | Number of unique values in a range or array |
COUNTIF.3D | Same as COUNTIF working with 3D references |
DATE.DIFF | Returns an age in years, months and days |
EASTERDATE | Date of Easter Sunday for a given year |
EVAL | Evaluates a formula or expression |
FILENAME | Name of the workbook. WORKBOOKFILENAME |
FORMULATEXT | Returns the formula of a cell. FORMULATEXT |
GEOMEAN.EXT | Same as GEOMEAN, higher capacity |
GETV | Returns a temporary variable value stored by SETV |
HEX.AND | Bitwise AND between hexadecimal numbers |
HEX.FORMAT | Formats and checks the validity of an hexadecimal number |
HEX.NEG | Inverts the sign of an hexadecimal number (2's complement) |
HEX.NOT | Negates (NOT) an hexadecimal number |
HEX.OR | Bitwise OR between hexadecimal numbers |
HEX.SUM | Adds hexadecimal numbers |
HSORT | Sorts a range or an array (supports up to 14 sort keys) - vertical SORT added in Excel 2021 |
HSORT.IDX | Sort index of a range or array (supports up to 14 sort keys) - vertical |
INDIRECT.EXT | same as INDIRECT working also with closed workbooks. VSTACK |
INTVECTOR | Returns a vector of consecutive integers in the ascending order |
ISO.WEEKNUM | ISO-compliant week number of a day. Excel 2013 added ISOWEEKNUM |
LASTROW | Last filled cell in a column. LASTINROW |
MATRIXROUND | Adjusts an array of rounded numbers (=>sum of percentages = always 100%) |
MCONCAT | Concatenates all values in a range or an array |
MDETERM.EXT | Same as MDETERM, faster and supporting larger arrays |
MINVERSE.EXT | Same as MINVERSE, faster and supporting larger arrays |
MMAX | Returns the N highest numbers of a range or an array |
MMIN | Returns the N lowest numbers of a range or an array |
MMULT.EXT | Same as MMULT, faster and supporting larger arrays |
MRAND | Series of random integers without repetitions |
NBTEXT | Converts a positive number into spelled-out text (supports 13 languages) |
PAGENUM | Page number of a cell |
PN.ISPRIME | Returns TRUE if a number is a prime number (up to 255 digits) |
PN.NEXT | Returns the next prime number (up to 255 digits) |
RECALL | Returns the previous value of the calling cell before the last calculation |
REGEX.COMP | Returns TRUE if a text matches a regular expression |
REGEX.COUNT | Counts the matches of a regular expression in a string |
REGEX.FIND | Location of a substring matching a regular expression |
REGEX.LEN | Counts the matches of a regular expression in a string |
REGEX.MID | Returns a substring matching a regular expression |
REGEX.SUBSTITUTE | Replaces a substring matching a regular expression with a new string |
SETV | Stores a value in a temporary variable |
SHEETNAME | Name of a sheet in the workbook. WORKSHEETNAME |
SHEETOFFSET | Returns a range that is a specified number of sheets from a range |
STDEV.GROUPED | Standard deviation based on a sample (data grouped in classes) |
STDEVP.GROUPED | Standard deviation based on the entire population (grouped data) |
TEXTREVERSE | Reverses the characters of a string. REVERSE |
THREED | Coerces a 3D range into a single array - enables array formulae with 3D references |
UNION.OFFSET | OFFSET-like function working with unions (discontinguous ranges) |
UNIQUEVALUES | Added in 2021 UNIQUE |
VAR.GROUPED | Variance based on a sample (data grouped in classes) |
VARP.GROUPED | Variance based on the entire population (grouped data) |
VSORT | Sorts a range or an array (supports up to 14 sort keys) - horizontal SORT added in Excel 2021 |
VSORT.IDX | Sort index of a range or array (supports up to 14 sort keys) - horizontal |
WEIGHTED.AVERAGE | Returns a weighted average |
WMID | Extracts a word or a group of words from a text |
WORDCOUNT | Number of words in a text WORDCOUNT |
Library Function Description |
ANSI128 Strips the accents from a string |
ARRAY.FILTER Returns only the visible cells of a range (in an array) |
ARRAY.JOIN Joins various items (ranges, unions, strings, numbers...) in a single array |
CHBASE Converts a value from a base into another base |
COUNTDIFF Number of unique values in a range or array |
COUNTIF.3D Same as COUNTIF working with 3D references |
DATE.DIFF Returns an age in years, months and days |
EASTERDATE Date of Easter Sunday for a given year |
EVAL Evaluates a formula or expression |
FILENAME Name of the workbook. WORKBOOKFILENAME |
FORMULATEXT Returns the formula of a cell. FORMULATEXT |
GEOMEAN.EXT Same as GEOMEAN, higher capacity |
GETV Returns a temporary variable value stored by SETV |
HEX.AND Bitwise AND between hexadecimal numbers |
HEX.FORMAT Formats and checks the validity of an hexadecimal number |
HEX.NEG Inverts the sign of an hexadecimal number (2's complement) |
HEX.NOT Negates (NOT) an hexadecimal number |
HEX.OR Bitwise OR between hexadecimal numbers |
HEX.SUM Adds hexadecimal numbers |
HSORT Sorts a range or an array (supports up to 14 sort keys) - vertical SORT added in Excel 2021 |
HSORT.IDX Sort index of a range or array (supports up to 14 sort keys) - vertical |
INDIRECT.EXT same as INDIRECT working also with closed workbooks. VSTACK |
INTVECTOR Returns a vector of consecutive integers in the ascending order |
ISO.WEEKNUM ISO-compliant week number of a day. Excel 2013 added ISOWEEKNUM |
LASTROW Last filled cell in a column. LASTINROW |
MATRIXROUND Adjusts an array of rounded numbers (=>sum of percentages = always 100%) |
MCONCAT Concatenates all values in a range or an array |
MDETERM.EXT Same as MDETERM, faster and supporting larger arrays |
MINVERSE.EXT Same as MINVERSE, faster and supporting larger arrays |
MMAX Returns the N highest numbers of a range or an array |
MMIN Returns the N lowest numbers of a range or an array |
MMULT.EXT Same as MMULT, faster and supporting larger arrays |
MRAND Series of random integers without repetitions |
NBTEXT Converts a positive number into spelled-out text (supports 13 languages) |
PAGENUM Page number of a cell |
PN.ISPRIME Returns TRUE if a number is a prime number (up to 255 digits) |
PN.NEXT Returns the next prime number (up to 255 digits) |
RECALL Returns the previous value of the calling cell before the last calculation |
REGEX.COMP Returns TRUE if a text matches a regular expression |
REGEX.COUNT Counts the matches of a regular expression in a string |
REGEX.FIND Location of a substring matching a regular expression |
REGEX.LEN Counts the matches of a regular expression in a string |
REGEX.MID Returns a substring matching a regular expression |
REGEX.SUBSTITUTE Replaces a substring matching a regular expression with a new string |
SETV Stores a value in a temporary variable |
SHEETNAME Name of a sheet in the workbook. WORKSHEETNAME |
SHEETOFFSET Returns a range that is a specified number of sheets from a range |
STDEV.GROUPED Standard deviation based on a sample (data grouped in classes) |
STDEVP.GROUPED Standard deviation based on the entire population (grouped data) |
TEXTREVERSE Reverses the characters of a string. REVERSE |
THREED Coerces a 3D range into a single array - enables array formulae with 3D references |
UNION.OFFSET OFFSET-like function working with unions (discontinguous ranges) |
UNIQUEVALUES Added in 2021 UNIQUE |
VAR.GROUPED Variance based on a sample (data grouped in classes) |
VARP.GROUPED Variance based on the entire population (grouped data) |
VSORT Sorts a range or an array (supports up to 14 sort keys) - horizontal SORT added in Excel 2021 |
VSORT.IDX Sort index of a range or array (supports up to 14 sort keys) - horizontal |
WEIGHTED.AVERAGE Returns a weighted average |
WMID Extracts a word or a group of words from a text |
WORDCOUNT Number of words in a text WORDCOUNT |
Excel Kid Functions
link - excelkid.com/excel-functions/
Library Function | Description |
ABBREVIATE | (Text) |
ASG | |
AVERAGE_FLN | (Maths) |
AVERAGEHIGH | (Maths) |
AVERAGELOW | (Maths) |
AVERAGEN | (Maths) |
AVERAGESHEET | (Maths) |
BETWEEN | |
CAMEL_CASE | (Text) |
CAPITALIZE | (Text) |
CELLARRAY | |
COMPANY_CASE | (Text) |
COMPARE | Compare two lists or ranges and extract values based on different aspects. |
COMPUTER_NAME | |
CONCAT_365 | (Text) |
CONCATIF | |
CONCATIFS | |
COUNT_LOWERCASE | (Text) |
COUNT_UPPERCASE | (Text) |
COUNT_WORDS | (Text) WORDCOUNT |
COUNTBETWEEN | (Maths) |
COUNTDIGITS | (Maths) |
COUNTTEXT | (Maths) |
COUNTUNIQUE | (Maths) |
COUNTVISIBLE | (Maths) |
COUNTX | (Maths) |
CRNG | |
DAM_STR | (Text) |
DAMERAU | (Text) |
DASH_CASE | (Text) |
DATE_TO_YYYYWW | (Date & Time) |
DATEDIFF | (Date & Time) |
DAYS_OF_MONTH | (Date & Time) |
DEDENT | (Text) |
DELIMSTR | (Text) |
DXLOOKUP | |
ELITE_CASE | (Text) |
F_CAGR | |
F_CAGR2 | |
F_DEPRECIATION | |
F_EXTENDAP | |
F_EXTENDGP | |
F_INCOMETAX | |
F_LIMIT | |
F_PAYOUT | |
F_PBP | |
FILTER_WORDS | (Text) |
FIRST_UNIQUE | |
FIRSTINCOLUMN | |
FIRSTINROW | |
FRNG | |
FUNCIFS | |
GET_CELLCOLOR | |
GET_COMMENT | |
GET_FONT | |
GET_HEIGHT | |
GET_HYPERLINK | |
GET_RANGENAME | |
GET_URL | |
GET_WIDTH | |
GETLASTWORD | (Text) |
GETNUMBERS | (Text) |
GETNWORDS | (Text) |
GETWORDS | (Text) |
HAMMING | (Text) |
HEX2HSL | |
HEX2RGB | |
HSL2HEX | |
HSL2RGB | |
IFEQUAL | |
IFS_365 | |
IFXRETURN | |
ILOOKUP | |
INDENT | (Text) |
INRANGE | Checks if a specific value or a range exists within another range and returns a boolean value. |
INSPLIT | (Text) |
INSTRING | (Text) |
INTERPOLATE_NUMBER | (Maths) |
INTERPOLATE_PERCENT | (Maths) |
ISBOLD | |
LARGEIFS | |
LASTINCOLUMN | |
LASTINROW | |
LDATE | (Date & Time) |
LEFT_FIND | (Text) |
LEFT_SEARCH | (Text) |
LEFT_SPLIT | (Text) |
LEV_STR | (Text) |
LEVENSHTEIN | (Text) |
MAX_IF | |
MAX_IFS | |
MAX_RANGE | (Maths) |
MAXN | |
MAXSHEET | (Maths) |
MAXSHEETS | (Maths) |
MIN_IF | |
MIN_IFS | |
MIN_RANGE | (Maths) |
MINN | |
MINSHEET | (Maths) |
MINSHEETS | (Maths) |
MLOOKUP | |
MLOOKUP_NR | |
MONTH_NAME | (Date & Time) |
NMATCH | |
NMATCHIFS | |
NOTBETWEEN | |
NVLOOKUP | |
NVLOOKUPIFS | |
OS | |
PERCENTAGEIFS | |
QUARTER | (Date & Time) |
QUARTER_NUM | (Date & Time) |
RANDBOOL | |
RANDOM_RANGE | |
RANDOM_SAMPLE | |
RANDOM_SAMPLE_PERCENT | |
RANGE_REVERSE | |
RANGE_SORT | |
REMOVE_CHARACTERS | (Text) |
REMOVE_FIRST_N_CHAR | (Text) |
REMOVE_LAST_N_CHAR | (Text) |
REPEAT | (Text) |
REPTX | |
RETURNCOLUMNS | |
REVERSE_TEXT | (Text) |
REVERSE_WORDS | (Text) |
RGB2HEX | |
RGB2HSL | |
RGB2HSV | |
RIGHT_FIND | (Text) |
RIGHT_SEARCH | (Text) |
RIGHT_SPLIT | (Text) |
RTOTAL | |
SEQUENCER | |
SHEET_CODE_NAME | |
SHEET_NAME | |
SHORTEN | (Text) |
SMALLIFS | |
SPLITIT | |
SPLITNUMBERS | (Text) |
STDEVIFS | |
STR_COUNT | (Text) |
STR_SORT | (Text) |
SUBSTITUTE_ALL | (Text) |
SUBSTITUTES | (Text) |
SUBSTR | (Text) |
SUBSTR_FIND | (Text) |
SUBSTR_SEARCH | (Text) |
SUMBETWEEN | (Maths) |
SUMHIGH | (Maths) |
SUMLOW | (Maths) |
SUMN | (Maths) |
SUMSHEET | (Maths) |
SUMSHEETS | (Maths) |
SUMTEXT | (Maths) |
SWITCH_365 | |
TEXT_INSERT | (Text) |
TEXT_JOIN | (Text) |
TEXT_LEFT | (Text) |
TEXTCLEAN | (Text) |
TEXTIFS | |
TIMECARD | (Date & Time) |
TIME-CONVERTER | (Date & Time) |
TOTALCOL | |
TOTALROW | |
TRIM_RIGHT | (Text) |
UNIQUE_365 | |
USER_NAME | USERNAME |
UTEXT | (Maths) |
VRNG | |
WB_AUTHOR | |
WB_CATEGORY | |
WB_COMMENTS | |
WB_COMPANY | |
WB_CREATION_DATE | |
WB_KEYWORDS | |
WB_LAST_AUTHOR | |
WB_LAST_SAVE_TIME | |
WB_MANAGER | |
WB_SUBJECT | |
WB_TITLE | |
WEEK_OF_MONTH | (Date & Time) |
WEEKDAY_NAME | (Date & Time) |
WEEKENDDATE | (Date & Time) |
WORDFREQ | (Text) |
WORKTIME | (Date & Time) |
XDATE | (Date & Time) |
YYWW_TO_DATE | (Date & Time) |
YYYYMMDD_TO_DATE | (Date & Time) |
ZFILL | (Text) |
Library Function Description |
ABBREVIATE (Text) |
ASG |
AVERAGE_FLN (Maths) |
AVERAGEHIGH (Maths) |
AVERAGELOW (Maths) |
AVERAGEN (Maths) |
AVERAGESHEET (Maths) |
BETWEEN |
CAMEL_CASE (Text) |
CAPITALIZE (Text) |
CELLARRAY |
COMPANY_CASE (Text) |
COMPARE Compare two lists or ranges and extract values based on different aspects. |
COMPUTER_NAME |
CONCAT_365 (Text) |
CONCATIF |
CONCATIFS |
COUNT_LOWERCASE (Text) |
COUNT_UPPERCASE (Text) |
COUNT_WORDS (Text) WORDCOUNT |
COUNTBETWEEN (Maths) |
COUNTDIGITS (Maths) |
COUNTTEXT (Maths) |
COUNTUNIQUE (Maths) |
COUNTVISIBLE (Maths) |
COUNTX (Maths) |
CRNG |
DAM_STR (Text) |
DAMERAU (Text) |
DASH_CASE (Text) |
DATE_TO_YYYYWW (Date & Time) |
DATEDIFF (Date & Time) |
DAYS_OF_MONTH (Date & Time) |
DEDENT (Text) |
DELIMSTR (Text) |
DXLOOKUP |
ELITE_CASE (Text) |
F_CAGR |
F_CAGR2 |
F_DEPRECIATION |
F_EXTENDAP |
F_EXTENDGP |
F_INCOMETAX |
F_LIMIT |
F_PAYOUT |
F_PBP |
FILTER_WORDS (Text) |
FIRST_UNIQUE |
FIRSTINCOLUMN |
FIRSTINROW |
FRNG |
FUNCIFS |
GET_CELLCOLOR |
GET_COMMENT |
GET_FONT |
GET_HEIGHT |
GET_HYPERLINK |
GET_RANGENAME |
GET_URL |
GET_WIDTH |
GETLASTWORD (Text) |
GETNUMBERS (Text) |
GETNWORDS (Text) |
GETWORDS (Text) |
HAMMING (Text) |
HEX2HSL |
HEX2RGB |
HSL2HEX |
HSL2RGB |
IFEQUAL |
IFS_365 |
IFXRETURN |
ILOOKUP |
INDENT (Text) |
INRANGE Checks if a specific value or a range exists within another range and returns a boolean value. |
INSPLIT (Text) |
INSTRING (Text) |
INTERPOLATE_NUMBER (Maths) |
INTERPOLATE_PERCENT (Maths) |
ISBOLD |
LARGEIFS |
LASTINCOLUMN |
LASTINROW |
LDATE (Date & Time) |
LEFT_FIND (Text) |
LEFT_SEARCH (Text) |
LEFT_SPLIT (Text) |
LEV_STR (Text) |
LEVENSHTEIN (Text) |
MAX_IF |
MAX_IFS |
MAX_RANGE (Maths) |
MAXN |
MAXSHEET (Maths) |
MAXSHEETS (Maths) |
MIN_IF |
MIN_IFS |
MIN_RANGE (Maths) |
MINN |
MINSHEET (Maths) |
MINSHEETS (Maths) |
MLOOKUP |
MLOOKUP_NR |
MONTH_NAME (Date & Time) |
NMATCH |
NMATCHIFS |
NOTBETWEEN |
NVLOOKUP |
NVLOOKUPIFS |
OS |
PERCENTAGEIFS |
QUARTER (Date & Time) |
QUARTER_NUM (Date & Time) |
RANDBOOL |
RANDOM_RANGE |
RANDOM_SAMPLE |
RANDOM_SAMPLE_PERCENT |
RANGE_REVERSE |
RANGE_SORT |
REMOVE_CHARACTERS (Text) |
REMOVE_FIRST_N_CHAR (Text) |
REMOVE_LAST_N_CHAR (Text) |
REPEAT (Text) |
REPTX |
RETURNCOLUMNS |
REVERSE_TEXT (Text) |
REVERSE_WORDS (Text) |
RGB2HEX |
RGB2HSL |
RGB2HSV |
RIGHT_FIND (Text) |
RIGHT_SEARCH (Text) |
RIGHT_SPLIT (Text) |
RTOTAL |
SEQUENCER |
SHEET_CODE_NAME |
SHEET_NAME |
SHORTEN (Text) |
SMALLIFS |
SPLITIT |
SPLITNUMBERS (Text) |
STDEVIFS |
STR_COUNT (Text) |
STR_SORT (Text) |
SUBSTITUTE_ALL (Text) |
SUBSTITUTES (Text) |
SUBSTR (Text) |
SUBSTR_FIND (Text) |
SUBSTR_SEARCH (Text) |
SUMBETWEEN (Maths) |
SUMHIGH (Maths) |
SUMLOW (Maths) |
SUMN (Maths) |
SUMSHEET (Maths) |
SUMSHEETS (Maths) |
SUMTEXT (Maths) |
SWITCH_365 |
TEXT_INSERT (Text) |
TEXT_JOIN (Text) |
TEXT_LEFT (Text) |
TEXTCLEAN (Text) |
TEXTIFS |
TIMECARD (Date & Time) |
TIME-CONVERTER (Date & Time) |
TOTALCOL |
TOTALROW |
TRIM_RIGHT (Text) |
UNIQUE_365 |
USER_NAME USERNAME |
UTEXT (Maths) |
VRNG |
WB_AUTHOR |
WB_CATEGORY |
WB_COMMENTS |
WB_COMPANY |
WB_CREATION_DATE |
WB_KEYWORDS |
WB_LAST_AUTHOR |
WB_LAST_SAVE_TIME |
WB_MANAGER |
WB_SUBJECT |
WB_TITLE |
WEEK_OF_MONTH (Date & Time) |
WEEKDAY_NAME (Date & Time) |
WEEKENDDATE (Date & Time) |
WORDFREQ (Text) |
WORKTIME (Date & Time) |
XDATE (Date & Time) |
YYWW_TO_DATE (Date & Time) |
YYYYMMDD_TO_DATE (Date & Time) |
ZFILL (Text) |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext