Function Migration
Our list of initial functions has been taken from the following add-ins: ASAP Utilities, Power Utility Pack, KuTools, OzGrid and MoreFunc.
ASAP Utilities
link - asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=259
| Library Function | Description |
| ASAPCELLCOLOR | Returns the color number of the cell. |
| 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 |
| ASAPCOUNTWORDS | Returns the number of words in a text value, cell, or range. |
| 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 |
| ASAPFONTCOLOR | Returns the color number of the font of a cell. |
| 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. |
| ASAPGETINDENTLEVEL | Returns the indent level for the cell. |
| 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 |
| ASAPREGEXMATCH | Returns TRUE if the value matches the regular expression and FALSE if it does not. |
| ASAPREGEXEXTRACT | Returns the text that matches the regular expression. |
| ASAPREGEXREPLACE | Returns a modified version of the text string based on a regular expression. |
| 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 |
| ASAPCELLCOLOR Returns the color number of the cell. |
| 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 |
| ASAPCOUNTWORDS Returns the number of words in a text value, cell, or range. |
| 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 |
| ASAPFONTCOLOR Returns the color number of the font of a cell. |
| 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. |
| ASAPGETINDENTLEVEL Returns the indent level for the cell. |
| 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 |
| ASAPREGEXMATCH Returns TRUE if the value matches the regular expression and FALSE if it does not. |
| ASAPREGEXEXTRACT Returns the text that matches the regular expression. |
| ASAPREGEXREPLACE Returns a modified version of the text string based on a regular expression. |
| 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
link - extendoffice.com/product/kutools-for-excel/excel-sum-count-average-visible-cells-only.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 |
| AI_ANSWER | Provide an answer to a question |
| AI_CATEGORIZE | Assign categories to rows of data |
| AI_CLASSIFYTEXT | Categorise text into labels |
| AI_CLEANTEXT | Remove noise, fix formatting |
| AI_COMPARETEXT | Compare two texts for similarity |
| AI_CORRECTTEXT | Grammar and spelling correction |
| AI_DETECTINTENT | Identify intent (e.g., complaint, request) |
| AI_DETECTLANGUAGE | Identify the language of text |
| AI_EXPANDTEXT | Expand text (make longer) |
| AI_EXPLAIN | Explain a concept |
| AI_EXTRACTADDRESS | Postal addresses |
| AI_EXTRACTCURRENCY | Money amounts |
| AI_EXTRACTDATE | Dates in any format |
| AI_EXTRACTDATETIME | Combined date/time |
| AI_EXTRACTEMAIL | Email addresses |
| AI_EXTRACTKEYWORDS | Keywords from text |
| AI_EXTRACTNUMBER | Numeric values |
| AI_EXTRACTPHONE | Phone numbers |
| AI_EXTRACTSUMMARY | Short summary of text |
| AI_EXTRACTTIME | Times |
| AI_EXTRACTURL | URLs / website links |
| AI_FILLDATA | Fill missing data intelligently |
| AI_FIXFORMULA | Repair broken Excel formulas |
| AI_FORMATTEXT | Apply a specific style (formal, concise, etc.) |
| AI_GENERATEFORMULA | Convert natural language into an Excel formula |
| AI_GENERATETEXT | Create text based on a prompt |
| AI_KEYPOINTS | Extract bullet-point insights |
| AI_REWRITE | Rewrite text in a different tone/style |
| AI_SENTIMENT | Positive / negative / neutral sentiment |
| AI_SHORTENTEXT | Condense text (make shorter) |
| AI_STANDARDIZETEXT | Convert text to a consistent format |
| AI_SUMMARIZE | Summarise long text |
| AI_TAGTEXT | Add tags based on content |
| AI_TRANSLATE | Translate text between languages |
| 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 |
| AI_ANSWER Provide an answer to a question |
| AI_CATEGORIZE Assign categories to rows of data |
| AI_CLASSIFYTEXT Categorise text into labels |
| AI_CLEANTEXT Remove noise, fix formatting |
| AI_COMPARETEXT Compare two texts for similarity |
| AI_CORRECTTEXT Grammar and spelling correction |
| AI_DETECTINTENT Identify intent (e.g., complaint, request) |
| AI_DETECTLANGUAGE Identify the language of text |
| AI_EXPANDTEXT Expand text (make longer) |
| AI_EXPLAIN Explain a concept |
| AI_EXTRACTADDRESS Postal addresses |
| AI_EXTRACTCURRENCY Money amounts |
| AI_EXTRACTDATE Dates in any format |
| AI_EXTRACTDATETIME Combined date/time |
| AI_EXTRACTEMAIL Email addresses |
| AI_EXTRACTKEYWORDS Keywords from text |
| AI_EXTRACTNUMBER Numeric values |
| AI_EXTRACTPHONE Phone numbers |
| AI_EXTRACTSUMMARY Short summary of text |
| AI_EXTRACTTIME Times |
| AI_EXTRACTURL URLs / website links |
| AI_FILLDATA Fill missing data intelligently |
| AI_FIXFORMULA Repair broken Excel formulas |
| AI_FORMATTEXT Apply a specific style (formal, concise, etc.) |
| AI_GENERATEFORMULA Convert natural language into an Excel formula |
| AI_GENERATETEXT Create text based on a prompt |
| AI_KEYPOINTS Extract bullet-point insights |
| AI_REWRITE Rewrite text in a different tone/style |
| AI_SENTIMENT Positive / negative / neutral sentiment |
| AI_SHORTENTEXT Condense text (make shorter) |
| AI_STANDARDIZETEXT Convert text to a consistent format |
| AI_SUMMARIZE Summarise long text |
| AI_TAGTEXT Add tags based on content |
| AI_TRANSLATE Translate text between languages |
Power User Software
link - 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 | Returns the author, who has initially created the workbook. |
| PROFEXBackgroundColor | Returns the background color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| PROFEXCellFormatCodeFunction | Returns the exact format code from a cell. |
| PROFEXColumn | Returns the column letter (not number) of a cell. |
| PROFEXCommentAuthorName | Returns the name of the person who added the initial comment (new in Excel 365). |
| PROFEXCommentReplyAuthorName | Returns the name of the person who added the n-th comment (new in Excel 365). |
| PROFEXCommentReply | Returns the text of a reply comment (new in Excel 365). The older comments in Excel are called notes now. |
| PROFEXCommentText | Returns the text of a threaded comment (new in Excel 365). The older comments in Excel are called notes now. |
| PROFEXDateCreated | Returns the date on which the workbook was created. WORKBOOKPROPERTIES |
| PROFEXDateLastSaved | Returns the date on which the workbook was saved the last time.PROFEXFileName Returns the filename of a cell. WORKBOOKPROPERTIES |
| PROFEXFileSize | Returns the file size of the workbook. |
| PROFEXFolderName | Returns the name of the folder in which the workbook is saved in. |
| PROFEXFontColor | Returns the font color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| PROFEXHasStrikethrough | Returns TRUE if the cell is formatted with strikethrough and FALSE if the cell is not formatted with strikethrough. |
| PROFEXHyperlinkAddress | Returns the hyperlink of a cell if available.PROFEXIndentLevel Returns the indentation of a cell. |
| PROFEXIndentLevel | |
| PROFEXIsVisible | Returns TRUE if the cell is visible. If the row or column is hidden, grouped or filtered, PROFEXIsVisible Returns FALSE. |
| PROFEXLastSavedBy | Returns the name of the person who saved the workbook the last time. WORKBOOKPROPERTIES |
| PROFEXMaxIf | MAXIFS added in 2019 to the Statistical category. Returns the maximum value of a cell range depending on a criteria in another cell range. |
| PROFEXMinIf | MINIFS was added in 2019 to the Statistical category. Returns the minimum value of a cell range depending on a criteria in another cell range. |
| PROFEXNoteText | Returns the text of a note (a simple comment, not the new threaded comments in Excel 365). If you want to return the text from the newer threaded comments, please use the formula PROFEXCommentText. |
| PROFEXNumberOfHiddenWorksheets | Returns the number of hidden worksheets. COUNTHIDDENSHEETS |
| PROFEXNumberOfWorksheets | SHEETS added in 2016 to the Information category. The total number of worksheets - 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 | Returns the name of the worksheet this cell is on. |
| PROFEXText | Returns the text of a threaded comment |
| PROFEXWeekdayName | Returns the name of the weekday in English. |
| PROFEXWorkbookPath | Returns the path of the workbook. |
| Library Function Description |
| PROFEXAuthor Returns the author, who has initially created the workbook. |
| PROFEXBackgroundColor Returns the background color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| PROFEXCellFormatCodeFunction Returns the exact format code from a cell. |
| PROFEXColumn Returns the column letter (not number) of a cell. |
| PROFEXCommentAuthorName Returns the name of the person who added the initial comment (new in Excel 365). |
| PROFEXCommentReplyAuthorName Returns the name of the person who added the n-th comment (new in Excel 365). |
| PROFEXCommentReply Returns the text of a reply comment (new in Excel 365). The older comments in Excel are called notes now. |
| PROFEXCommentText Returns the text of a threaded comment (new in Excel 365). The older comments in Excel are called notes now. |
| PROFEXDateCreated Returns the date on which the workbook was created. WORKBOOKPROPERTIES |
| PROFEXDateLastSaved Returns the date on which the workbook was saved the last time.PROFEXFileName Returns the filename of a cell. WORKBOOKPROPERTIES |
| PROFEXFileSize Returns the file size of the workbook. |
| PROFEXFolderName Returns the name of the folder in which the workbook is saved in. |
| PROFEXFontColor Returns the font color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| PROFEXHasStrikethrough Returns TRUE if the cell is formatted with strikethrough and FALSE if the cell is not formatted with strikethrough. |
| PROFEXHyperlinkAddress Returns the hyperlink of a cell if available.PROFEXIndentLevel Returns the indentation of a cell. |
| PROFEXIndentLevel |
| PROFEXIsVisible Returns TRUE if the cell is visible. If the row or column is hidden, grouped or filtered, PROFEXIsVisible Returns FALSE. |
| PROFEXLastSavedBy Returns the name of the person who saved the workbook the last time. WORKBOOKPROPERTIES |
| PROFEXMaxIf MAXIFS added in 2019 to the Statistical category. Returns the maximum value of a cell range depending on a criteria in another cell range. |
| PROFEXMinIf MINIFS was added in 2019 to the Statistical category. Returns the minimum value of a cell range depending on a criteria in another cell range. |
| PROFEXNoteText Returns the text of a note (a simple comment, not the new threaded comments in Excel 365). If you want to return the text from the newer threaded comments, please use the formula PROFEXCommentText. |
| PROFEXNumberOfHiddenWorksheets Returns the number of hidden worksheets. COUNTHIDDENSHEETS |
| PROFEXNumberOfWorksheets SHEETS added in 2016 to the Information category. The total number of worksheets - 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 Returns the name of the worksheet this cell is on. |
| PROFEXText Returns the text of a threaded comment |
| PROFEXWeekdayName Returns the name of the weekday in English. |
| PROFEXWorkbookPath Returns the path of the workbook. |
XLTools
link - https://xltools.net/xl-functions/
| Library Function | Description |
| XL.ComputeMD5Hash | Encodes a text string to an MD5 hash |
| XL.Concatenate | Concatenates all values in a range into a single string with any separator |
| XL.CountWords | Counts the number of words in a range |
| XL.DateAdd | Adds years, quarters, months, days, minutes, hours and seconds to a date |
| XL.DateToTicks | Converts date and time values into the number of ticks |
| XL.FindEmail | Finds and extracts an email address from a text string |
| XL.FindNumber | Finds and extracts a number from a text string |
| XL.FormatDate | Changes format of date and time values |
| XL.FormatPhoneNumber | Formats a string as a phone number |
| XL.HexColorToRGB | Converts Hex color code to RGB format |
| XL.Random | Generates an array of random numbers, including unique random numbers |
| XL.StringFormat | Creates text strings with dynamically filled placeholders |
| Library Function Description |
| XL.ComputeMD5Hash Encodes a text string to an MD5 hash |
| XL.Concatenate Concatenates all values in a range into a single string with any separator |
| XL.CountWords Counts the number of words in a range |
| XL.DateAdd Adds years, quarters, months, days, minutes, hours and seconds to a date |
| XL.DateToTicks Converts date and time values into the number of ticks |
| XL.FindEmail Finds and extracts an email address from a text string |
| XL.FindNumber Finds and extracts a number from a text string |
| XL.FormatDate Changes format of date and time values |
| XL.FormatPhoneNumber Formats a string as a phone number |
| XL.HexColorToRGB Converts Hex color code to RGB format |
| XL.Random Generates an array of random numbers, including unique random numbers |
| XL.StringFormat Creates text strings with dynamically filled placeholders |
Power Utility Pack
no longer supported
| Library Function | Description |
| Age | Calculate the age based on a date of birth. |
| 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 | COUNTVISIBLEA** |
| CountBetween | Counts the number of values in a range that fall between two values. COUNTBETWEEN |
| CountByColor | Counts the cells based on fill colour. |
| CountVisible | Counts the visible cells. |
| CreditCard | Returns a randomly generated valid-looking credit card number (2546 5635 8563 5747) |
| 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 | Strict linear interpolation between two known X-values across a row. Supporting exact match and between match. |
| HLookupExact | Returns exact-match horizontal lookup |
| InsertString | INSERTSTRING |
| IsBetween | Returns TRUE if a value lies between two bounds. |
| IsErrorType | Returns specific error codes. |
| IsFormula | TRUE if cell contains a formula. |
| IsInRange | Returns TRUE if a value is inside a range. |
| 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. |
| MonthWeek | Returns the calendar week for a date serial number WEEKNUMBER* |
| NumberFormat | NUMBERFORMATGET |
| NthInstance | Find the nth occurrence of a substring. |
| NthWord | Extract the nth word. |
| Ordinal | Convert 1 to 1st, 2 to 2nd, etc |
| ParseName | Splits a string that contains a name into its component parts: first name, middle name, and last name |
| ProperCaps | PROPER available since Excel 2003. The text string with the first letter of every word as a capital letter. |
| RandomDate | Returns a random date between two bounds. |
| RandomTime | Returns a random time between two bounds. |
| RandomText | Returns random strings. |
| RandomNumber | Returns random number with constraints. |
| RemoveSpaces | REMOVESPACES |
| SayIt | Used to speak the text that was in a cell by using the Windows SAPI voice. |
| 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. |
| SumAllSheets | Returns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS* |
| SumByColor | Returns the sum of the values based on cell colour. |
| 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 | Strict linear interpolation between two known X-values down a column. Supporting exact match and between match. |
| VlookupExact | Returns exact-match vertical lookup |
| 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 |
| Age Calculate the age based on a date of birth. |
| 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 COUNTVISIBLEA** |
| CountBetween Counts the number of values in a range that fall between two values. COUNTBETWEEN |
| CountByColor Counts the cells based on fill colour. |
| CountVisible Counts the visible cells. |
| CreditCard Returns a randomly generated valid-looking credit card number (2546 5635 8563 5747) |
| 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 Strict linear interpolation between two known X-values across a row. Supporting exact match and between match. |
| HLookupExact Returns exact-match horizontal lookup |
| InsertString INSERTSTRING |
| IsBetween Returns TRUE if a value lies between two bounds. |
| IsErrorType Returns specific error codes. |
| IsFormula TRUE if cell contains a formula. |
| IsInRange Returns TRUE if a value is inside a range. |
| 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. |
| MonthWeek Returns the calendar week for a date serial number WEEKNUMBER* |
| NumberFormat NUMBERFORMATGET |
| NthInstance Find the nth occurrence of a substring. |
| NthWord Extract the nth word. |
| Ordinal Convert 1 to 1st, 2 to 2nd, etc |
| ParseName Splits a string that contains a name into its component parts: first name, middle name, and last name |
| ProperCaps PROPER available since Excel 2003. The text string with the first letter of every word as a capital letter. |
| RandomDate Returns a random date between two bounds. |
| RandomTime Returns a random time between two bounds. |
| RandomText Returns random strings. |
| RandomNumber Returns random number with constraints. |
| RemoveSpaces REMOVESPACES |
| SayIt Used to speak the text that was in a cell by using the Windows SAPI voice. |
| 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. |
| SumAllSheets Returns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS* |
| SumByColor Returns the sum of the values based on cell colour. |
| 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 Strict linear interpolation between two known X-values down a column. Supporting exact match and between match. |
| VlookupExact Returns exact-match vertical lookup |
| 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
no longer supported
| 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
no longer supported
| 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
no longer supported
| 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) |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext