Function Migration
Our list of initial functions has been taken from the following add-ins:
AET Utilities, ASAP Utilities, Excel Kid, KuTools, MoreFunc, OzGrid, Power User Software, Power Utility Pack, Professor Excel, XLTools
AET Utilities
| Library Function | Description |
| BOOKSNAME | WORKBOOKFILENAME Returns Active Workbook's name |
| CHAIN | Built-in CONCAT Returns the text string that is a concatenation of cell ranges and strings. |
| CHOOSEFROMLIST | RANDFROMLIST add - Returns random values from a custom list, Optional TRUE to change on recalculation |
| CHOOSEFROMRANGE | RANDFROMLIST add - Returns random values from a range of cells, Optional TRUE to change on recalculation |
| COLORNAME | FORMATGET Returns the color name of the Target Cell. Use Optional CondFormat 1, 2 or 3 for Conditional Formatting. A blank or #NA will show in the case of an error |
| COLUMNSIZE | COLUMNWIDTH add - Returns the column width of a particular cell. |
| COMPANYNAMES | SAMPLEDATE Add fake company names, Optional TRUE to change on recalculation |
| CONVERTROMANNUMBERS | Convert roman numbers up until 3,999 |
| COUNTCOLOR | COUNTFORMAT Counts all cells of the colour specified (ColorInd = Color Index). It will not work with Conditional Formatting |
| DATEFORMAT | Select a number to change format of Target Cell or decline to retain same format as Target Cell. 1 = "dd/mm/yy"; 2 = "mm/dd/yy"; 3 = "d mmmm, yyyy"; 4 = "mmmm d, yyyy" |
| DATEFORMAT2 | Select a number to change format of TargetDate, can be used with TODAY, NOW or dates entered with commas. Formatting is the same as with DATEFORMAT |
| EDATEPLUS | Built-in EDATE Returns the date serial number that is a given number of months before or after a date. |
| EOMONTHPLUS | Built-in EOMONTH Returns the date serial number of the last day of a month before or after a date. |
| FEMALENAMES | SAMPLEDATA Add common female names (first names and surnames) |
| FIRSTINCOLUMN | FIRSTINCOLUMN add - Returns the First Value in the column specified |
| FIRSTINROW | FIRSTINROW add - Returns the First Value in the row specified |
| FULLNAME | WORKBOOKPATHFILENAME Returns Active Workbook's full name (includes directory) |
| GETCOLORINDEX | FORMATGET Returns the color index of the Target Cell. |
| GETCOMMENT | COMMENTGET Returns text from comment in Target Cell |
| GETFONT | FORMATGET Returns font name and size used in Target Cell |
| GETFONTINDEX | FORMATGET Returns the font color index of the Target Cell. Will not work with Number Formats |
| GETFORMAT | FORMATGET Returns format used in Target Cell |
| GETFORMULA | Built-in FORMULATEXT Returns formula used in Target Cell |
| GETFORMULAR1C1 | Returns R1C1 formula used in Target Cell |
| GETHTMLCOLOR | FORMATGET Returns HTML Color of Target Cell. It will not work with Conditional Formatting |
| GETNUMBERS | Returns numbers as string and retains leading zeros (all text is removed) |
| GETRGBCOLOR | FORMATGET Returns RGB Color of Target Cell. It will not work with Conditional Formatting |
| GETTEXT | Returns capital or small letters only (all numbers are removed) |
| GETTHEMECOLOR | FORMATGET Returns Theme Colour of Target Cell. It will not work with Conditional Formatting |
| GETTINTANDSHADE | FORMATGET Returns Tint And Shade of Target Cell. It will not work with Conditional Formatting |
| HASFORMULA | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| HASTEXT | Returns TRUE if text or numbers in second Target Cell are contained in first Target Cell |
| LASTDATE | Returns Last Date of a Month specified by MyDay (Sunday = 1, Monday = 2, Tuesday = 3 etc) |
| LASTINCOLUMN | LASTINCOLUMN Returns the Last Value in the column specified |
| LASTINROW | LASTINROW Returns the Last Value in the row specified |
| MAKE PASSWORD | Returns a random password based on number of characters and optional use of symbols |
| MALENAMES | SAMPLEDATA Add common male names (first names and surnames). |
| MILLIONS | ROUNDUPUNITS add - Round numbers up to millions as in "10 Million", recommended maximum of 15 digits |
| PATHNAME | WORKBOOKPATH Returns Active Workbook's path |
| REVERSETEXT | REVERSE Reverses Text of Target Cell |
| ROWSIZE | Returns Row Height of Active Cell if no range (Target Cell) is specified |
| SHEETSNAME | WORKSHEETNAME Returns Active Sheet's name |
| STATRAND | Returns static random numbers (similar to RAND) |
| STATRANDBETWEEN | Returns static random numbers between values specified (similar to RANDBETWEEN) |
| SUMCOLOR | SUMFORMAT Sums values in all cells of the color specified (ColorInd = Color Index). It will not work with Conditional Formatting |
| THOUSANDS | ROUNDUPUNITS add - Round numbers up to thousands as in "10 Thousand", recommended maximum of 12 digits |
| USERSNAME | USERNAME Returns the user's name |
| Library Function Description |
| BOOKSNAME WORKBOOKFILENAME Returns Active Workbook's name |
| CHAIN Built-in CONCAT Returns the text string that is a concatenation of cell ranges and strings. |
| CHOOSEFROMLIST RANDFROMLIST add - Returns random values from a custom list, Optional TRUE to change on recalculation |
| CHOOSEFROMRANGE RANDFROMLIST add - Returns random values from a range of cells, Optional TRUE to change on recalculation |
| COLORNAME FORMATGET Returns the color name of the Target Cell. Use Optional CondFormat 1, 2 or 3 for Conditional Formatting. A blank or #NA will show in the case of an error |
| COLUMNSIZE COLUMNWIDTH add - Returns the column width of a particular cell. |
| COMPANYNAMES SAMPLEDATE Add fake company names, Optional TRUE to change on recalculation |
| CONVERTROMANNUMBERS Convert roman numbers up until 3,999 |
| COUNTCOLOR COUNTFORMAT Counts all cells of the colour specified (ColorInd = Color Index). It will not work with Conditional Formatting |
| DATEFORMAT Select a number to change format of Target Cell or decline to retain same format as Target Cell. 1 = "dd/mm/yy"; 2 = "mm/dd/yy"; 3 = "d mmmm, yyyy"; 4 = "mmmm d, yyyy" |
| DATEFORMAT2 Select a number to change format of TargetDate, can be used with TODAY, NOW or dates entered with commas. Formatting is the same as with DATEFORMAT |
| EDATEPLUS Built-in EDATE Returns the date serial number that is a given number of months before or after a date. |
| EOMONTHPLUS Built-in EOMONTH Returns the date serial number of the last day of a month before or after a date. |
| FEMALENAMES SAMPLEDATA Add common female names (first names and surnames) |
| FIRSTINCOLUMN FIRSTINCOLUMN add - Returns the First Value in the column specified |
| FIRSTINROW FIRSTINROW add - Returns the First Value in the row specified |
| FULLNAME WORKBOOKPATHFILENAME Returns Active Workbook's full name (includes directory) |
| GETCOLORINDEX FORMATGET Returns the color index of the Target Cell. |
| GETCOMMENT COMMENTGET Returns text from comment in Target Cell |
| GETFONT FORMATGET Returns font name and size used in Target Cell |
| GETFONTINDEX FORMATGET Returns the font color index of the Target Cell. Will not work with Number Formats |
| GETFORMAT FORMATGET Returns format used in Target Cell |
| GETFORMULA Built-in FORMULATEXT Returns formula used in Target Cell |
| GETFORMULAR1C1 Returns R1C1 formula used in Target Cell |
| GETHTMLCOLOR FORMATGET Returns HTML Color of Target Cell. It will not work with Conditional Formatting |
| GETNUMBERS Returns numbers as string and retains leading zeros (all text is removed) |
| GETRGBCOLOR FORMATGET Returns RGB Color of Target Cell. It will not work with Conditional Formatting |
| GETTEXT Returns capital or small letters only (all numbers are removed) |
| GETTHEMECOLOR FORMATGET Returns Theme Colour of Target Cell. It will not work with Conditional Formatting |
| GETTINTANDSHADE FORMATGET Returns Tint And Shade of Target Cell. It will not work with Conditional Formatting |
| HASFORMULA Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| HASTEXT Returns TRUE if text or numbers in second Target Cell are contained in first Target Cell |
| LASTDATE Returns Last Date of a Month specified by MyDay (Sunday = 1, Monday = 2, Tuesday = 3 etc) |
| LASTINCOLUMN LASTINCOLUMN Returns the Last Value in the column specified |
| LASTINROW LASTINROW Returns the Last Value in the row specified |
| MAKE PASSWORD Returns a random password based on number of characters and optional use of symbols |
| MALENAMES SAMPLEDATA Add common male names (first names and surnames). |
| MILLIONS ROUNDUPUNITS add - Round numbers up to millions as in "10 Million", recommended maximum of 15 digits |
| PATHNAME WORKBOOKPATH Returns Active Workbook's path |
| REVERSETEXT REVERSE Reverses Text of Target Cell |
| ROWSIZE Returns Row Height of Active Cell if no range (Target Cell) is specified |
| SHEETSNAME WORKSHEETNAME Returns Active Sheet's name |
| STATRAND Returns static random numbers (similar to RAND) |
| STATRANDBETWEEN Returns static random numbers between values specified (similar to RANDBETWEEN) |
| SUMCOLOR SUMFORMAT Sums values in all cells of the color specified (ColorInd = Color Index). It will not work with Conditional Formatting |
| THOUSANDS ROUNDUPUNITS add - Round numbers up to thousands as in "10 Thousand", recommended maximum of 12 digits |
| USERSNAME USERNAME Returns the user's name |
link - sites.fastspring.com/andrewsexceltips/ product/andrewsexcelutilities
ASAP Utilities
| Library Function | Description |
| CELLCOLOR | FORMATGET Returns the colour number of a cell. |
| CELLCOLORINDEX | FORMATGET Returns the colour index number of the cell. |
| COUNTBYCELLCOLOR | COUNTFORMAT Counts the number of cells in the given range that have a certain fill colour. |
| COUNTBYFONTCOLOR | COUNTFORMAT Counts the number of cells in the given range that have a certain font colour. |
| COUNTCHAR | COUNTSUBSTRING Counts the number of times a character occurs in a text. |
| COUNTSHADES | COUNTFORMAT Counts the number of colored cells in your range. |
| COUNTWORDS | WORDCOUNT* Returns the number of words in a text value, cell, or range. |
| EXTRACTFILENAME | EXTRACTFILENAME Returns the file name from a full path and filename. |
| EXTRACTFOLDERNAME | EXTRACTFOLDERPATH Returns the folder name from a combined filepath and filename. |
| EXTRACTNUMBERS | EXTRACTNUMBERS Returns the numbers from a text string. |
| FILENAME | WORKBOOKFILENAME Returns the name of your workbook. |
| FILEPATH | WORKBOOKPATH Returns the filepath (the folder) where your workbook is stored. |
| FILEPROPERTIES | WORKBOOKPROPERTIES Returns the value of one of the built-in document properties for the current workbook. |
| FONTCOLOR | FORMATGET Returns the colour number of the font of a cell. |
| FONTCOLORINDEX | FORMATGET Returns the colour index number of the font of a cell. |
| FULLFILENAME | WORKBOOKPATHFILENAME Returns the full filename of your workbook. |
| GETCOMMENT | COMMENTGET Returns the text from the comment a cell. |
| GETDOMAIN | HYPERLINKGET Returns the (sub)domain from a given hyperlink (website address/url). |
| GETFONTNAME | FORMATGET Returns the name of the font in a cell. |
| GETFONTSIZE | FORMATGET Returns the font size of a cell. |
| GETFORMULA | Built-in FORMULATEXT Returns the formula from a particular cell. |
| GETFORMULAINT | Built-in FORMULATEXT Returns the formula from a particular cell. |
| GETINDENTLEVEL | FORMATGET Returns the indent level for the cell. |
| GETHYPERLINK | HYPERLINKGET Returns the hyperlink from a cell. |
| GETNUMBERFORMAT | NUMBERFORMATGET Returns the number format of a cell. |
| ISBOLD | ISBOLD Returns TRUE if the cell is bold or FALSE if it isn't. |
| ISFORMULA | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| LOADIMAGE | IMAGEDISPLAY* Inserts the specified image as an object and puts it at the left-top of your cell. |
| MERGECELLS | MERGECELLS Joins several text strings into one text string. |
| RANDOMPASSWORD | RANDOMPASSWORD Returns a random string that can be used as a password. |
| REGEXMATCH | REGEXMATCH add - Returns TRUE if the value matches the regular expression and FALSE if it does not. |
| REGEXEXTRACT | Built-in REGEXEXTRACT Returns the text that matches the regular expression. |
| REGEXREPLACE | Built-in REGEXREPLACE Returns a modified version of the text string based on a regular expression. |
| SHEETNAME | WORKSHEETNAME Returns the name of the worksheet this formula is used on. |
| SPELLNUMBER | SPELLNUMBER Returns the text after converting a number into words. |
| STRIPNUMBERS | REMOVENUMBERS Removes all numbers from a text string and removes all spaces at the beginning and end of the result. |
| SUMBYCELLCOLOR | SUMFORMAT Adds the cells that have a certain fill colour. |
| SUMBYFONTCOLOR | SUMFORMAT Adds the cells that have a certain font colour. |
| Library Function Description |
| CELLCOLOR FORMATGET Returns the colour number of a cell. |
| CELLCOLORINDEX FORMATGET Returns the colour index number of the cell. |
| COUNTBYCELLCOLOR COUNTFORMAT Counts the number of cells in the given range that have a certain fill colour. |
| COUNTBYFONTCOLOR COUNTFORMAT Counts the number of cells in the given range that have a certain font colour. |
| COUNTCHAR COUNTSUBSTRING Counts the number of times a character occurs in a text. |
| COUNTSHADES COUNTFORMAT Counts the number of colored cells in your range. |
| COUNTWORDS WORDCOUNT* Returns the number of words in a text value, cell, or range. |
| EXTRACTFILENAME EXTRACTFILENAME Returns the file name from a full path and filename. |
| EXTRACTFOLDERNAME EXTRACTFOLDERPATH Returns the folder name from a combined filepath and filename. |
| EXTRACTNUMBERS EXTRACTNUMBERS Returns the numbers from a text string. |
| FILENAME WORKBOOKFILENAME Returns the name of your workbook. |
| FILEPATH WORKBOOKPATH Returns the filepath (the folder) where your workbook is stored. |
| FILEPROPERTIES WORKBOOKPROPERTIES Returns the value of one of the built-in document properties for the current workbook. |
| FONTCOLOR FORMATGET Returns the colour number of the font of a cell. |
| FONTCOLORINDEX FORMATGET Returns the colour index number of the font of a cell. |
| FULLFILENAME WORKBOOKPATHFILENAME Returns the full filename of your workbook. |
| GETCOMMENT COMMENTGET Returns the text from the comment a cell. |
| GETDOMAIN HYPERLINKGET Returns the (sub)domain from a given hyperlink (website address/url). |
| GETFONTNAME FORMATGET Returns the name of the font in a cell. |
| GETFONTSIZE FORMATGET Returns the font size of a cell. |
| GETFORMULA Built-in FORMULATEXT Returns the formula from a particular cell. |
| GETFORMULAINT Built-in FORMULATEXT Returns the formula from a particular cell. |
| GETINDENTLEVEL FORMATGET Returns the indent level for the cell. |
| GETHYPERLINK HYPERLINKGET Returns the hyperlink from a cell. |
| GETNUMBERFORMAT NUMBERFORMATGET Returns the number format of a cell. |
| ISBOLD ISBOLD Returns TRUE if the cell is bold or FALSE if it isn't. |
| ISFORMULA Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| LOADIMAGE IMAGEDISPLAY* Inserts the specified image as an object and puts it at the left-top of your cell. |
| MERGECELLS MERGECELLS Joins several text strings into one text string. |
| RANDOMPASSWORD RANDOMPASSWORD Returns a random string that can be used as a password. |
| REGEXMATCH REGEXMATCH add - Returns TRUE if the value matches the regular expression and FALSE if it does not. |
| REGEXEXTRACT Built-in REGEXEXTRACT Returns the text that matches the regular expression. |
| REGEXREPLACE Built-in REGEXREPLACE Returns a modified version of the text string based on a regular expression. |
| SHEETNAME WORKSHEETNAME Returns the name of the worksheet this formula is used on. |
| SPELLNUMBER SPELLNUMBER Returns the text after converting a number into words. |
| STRIPNUMBERS REMOVENUMBERS Removes all numbers from a text string and removes all spaces at the beginning and end of the result. |
| SUMBYCELLCOLOR SUMFORMAT Adds the cells that have a certain fill colour. |
| SUMBYFONTCOLOR SUMFORMAT Adds the cells that have a certain font colour. |
link - asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=259
Excel Kid
| Library Function | Description |
| ABBREVIATE | ACRONYM Returns the first letter of each word. |
| ASG | |
| AVERAGE_FLN | (Maths) |
| AVERAGEHIGH | (Maths) |
| AVERAGELOW | (Maths) |
| AVERAGEN | (Maths) |
| AVERAGESHEET | (Maths) |
| BETWEEN | ISBETWEEN* Returns the boolean True or False depending if the value lies between two bounds. |
| 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 | WORDCOUNT* Returns the number of words in a string |
| COUNTBETWEEN | COUNTBETWEEN Returns the number of cells that have a value that is between "min_value" and "max_value". |
| COUNTDIGITS | (Maths) |
| COUNTTEXT | (Maths) |
| COUNTUNIQUE | nothing |
| COUNTVISIBLE | COUNTVISIBLE Returns the number of visible, non blank cells in a range. |
| COUNTX | (Maths) |
| CRNG | |
| DAM_STR | (Text) |
| DAMERAU | (Text) |
| DASH_CASE | (Text) |
| DATE_TO_YYYYWW | (Date & Time) |
| DATEDIFF | (Date & Time) |
| DAYS_OF_MONTH | DAYSINAMONTH - Returns the number of days in a month and year. |
| 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 | FORMATGET Returns a specific formatting attribute from a particular cell. |
| GET_COMMENT | COMMENTGET Returns the comment associated with a particular cell. |
| GET_FONT | FORMATGET Returns a specific formatting attribute from a particular cell. |
| GET_HEIGHT | |
| GET_HYPERLINK | |
| GET_RANGENAME | |
| GET_URL | HYPERLINKGET Returns the hyperlink associated with a particular cell. |
| GET_WIDTH | COLUMNWIDTH add - Returns the column width of a particular cell. |
| GETLASTWORD | WORDLAST* |
| GETNUMBERS | EXTRACTNUMBERS Returns only the numbers from a text string. |
| 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 | ISBOLD Returns whether a particular cell has been formatted in bold. |
| LARGEIFS | |
| LASTINCOLUMN | LASTINCOLUMN Returns the last cell that contains data in a particular column. |
| LASTINROW | LASTINROW Returns the last cell that contains data in a particular row. |
| LDATE | (Date & Time) |
| LEFT_FIND | (Text) |
| LEFT_SEARCH | (Text) |
| LEFT_SPLIT | (Text) |
| LEV_STR | (Text) |
| LEVENSHTEIN | (Text) |
| MAX_IF | Built-in MAXIFS Returns the largest numerical value that satisfies multiple conditions. |
| MAX_IFS | Built-in MAXIFS Returns the largest numerical value that satisfies multiple conditions. |
| MAX_RANGE | (Maths) |
| MAXN | MAXNO add - Returns the highest N number of items |
| MAXSHEET | (Maths) |
| MAXSHEETS | (Maths) |
| MIN_IF | Built-in MINIFS Returns the smallest numerical value that satisfies multiple conditions. |
| MIN_IFS | Built-in MINIFS Returns the smallest numerical value that satisfies multiple conditions. |
| MIN_RANGE | (Maths) |
| MINN | MINNO add - Returns the highest N number of items |
| 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 | Reverses a cell range |
| RANGE_SORT | Built-in SORT Returns the array of data that has been sorted by one column. |
| REMOVE_CHARACTERS | (Text) |
| REMOVE_FIRST_N_CHAR | (Text) |
| REMOVE_LAST_N_CHAR | (Text) |
| REPEAT | (Text) |
| REPTX | |
| RETURNCOLUMNS | |
| REVERSE_TEXT | REVERSE Returns the characters of a text string in reverse. |
| REVERSE_WORDS | REVERSE Returns the characters of a text string in reverse. |
| RGB2HEX | |
| RGB2HSL | |
| RGB2HSV | |
| RIGHT_FIND | (Text) |
| RIGHT_SEARCH | (Text) |
| RIGHT_SPLIT | (Text) |
| RTOTAL | |
| SEQUENCER | |
| SHEET_CODE_NAME | |
| SHEET_NAME | WORKSHEETNAME Returns the name of the worksheet in a given position. |
| 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 | Built-in CONCAT Returns the text string that is a concatenation of cell ranges and strings. |
| TEXT_LEFT | (Text) |
| TEXTCLEAN | (Text) |
| TEXTIFS | |
| TIMECARD | (Date & Time) |
| TIME-CONVERTER | (Date & Time) |
| TOTALCOL | |
| TOTALROW | |
| TRIM_RIGHT | (Text) |
| UNIQUE_365 | Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| USER_NAME | USERNAME Returns the application's user name or the domain username. |
| UTEXT | (Maths) |
| VRNG | |
| WB_AUTHOR | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_CATEGORY | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_COMMENTS | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_COMPANY | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_CREATION_DATE | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_KEYWORDS | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_LAST_AUTHOR | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_LAST_SAVE_TIME | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_MANAGER | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_SUBJECT | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_TITLE | WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WEEK_OF_MONTH | (Date & Time) |
| WEEKDAY_NAME | (Date & Time) |
| WEEKENDDATE | ISWEEKEND add |
| WORDFREQ | (Text) |
| WORKTIME | (Date & Time) |
| XDATE | (Date & Time) |
| YYWW_TO_DATE | (Date & Time) |
| YYYYMMDD_TO_DATE | (Date & Time) |
| ZFILL | (Text) |
| Library Function Description |
| ABBREVIATE ACRONYM Returns the first letter of each word. |
| ASG |
| AVERAGE_FLN (Maths) |
| AVERAGEHIGH (Maths) |
| AVERAGELOW (Maths) |
| AVERAGEN (Maths) |
| AVERAGESHEET (Maths) |
| BETWEEN ISBETWEEN* Returns the boolean True or False depending if the value lies between two bounds. |
| 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 WORDCOUNT* Returns the number of words in a string |
| COUNTBETWEEN COUNTBETWEEN Returns the number of cells that have a value that is between "min_value" and "max_value". |
| COUNTDIGITS (Maths) |
| COUNTTEXT (Maths) |
| COUNTUNIQUE nothing |
| COUNTVISIBLE COUNTVISIBLE Returns the number of visible, non blank cells in a range. |
| COUNTX (Maths) |
| CRNG |
| DAM_STR (Text) |
| DAMERAU (Text) |
| DASH_CASE (Text) |
| DATE_TO_YYYYWW (Date & Time) |
| DATEDIFF (Date & Time) |
| DAYS_OF_MONTH DAYSINAMONTH - Returns the number of days in a month and year. |
| 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 FORMATGET Returns a specific formatting attribute from a particular cell. |
| GET_COMMENT COMMENTGET Returns the comment associated with a particular cell. |
| GET_FONT FORMATGET Returns a specific formatting attribute from a particular cell. |
| GET_HEIGHT |
| GET_HYPERLINK |
| GET_RANGENAME |
| GET_URL HYPERLINKGET Returns the hyperlink associated with a particular cell. |
| GET_WIDTH COLUMNWIDTH add - Returns the column width of a particular cell. |
| GETLASTWORD WORDLAST* |
| GETNUMBERS EXTRACTNUMBERS Returns only the numbers from a text string. |
| 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 ISBOLD Returns whether a particular cell has been formatted in bold. |
| LARGEIFS |
| LASTINCOLUMN LASTINCOLUMN Returns the last cell that contains data in a particular column. |
| LASTINROW LASTINROW Returns the last cell that contains data in a particular row. |
| LDATE (Date & Time) |
| LEFT_FIND (Text) |
| LEFT_SEARCH (Text) |
| LEFT_SPLIT (Text) |
| LEV_STR (Text) |
| LEVENSHTEIN (Text) |
| MAX_IF Built-in MAXIFS Returns the largest numerical value that satisfies multiple conditions. |
| MAX_IFS Built-in MAXIFS Returns the largest numerical value that satisfies multiple conditions. |
| MAX_RANGE (Maths) |
| MAXN MAXNO add - Returns the highest N number of items |
| MAXSHEET (Maths) |
| MAXSHEETS (Maths) |
| MIN_IF Built-in MINIFS Returns the smallest numerical value that satisfies multiple conditions. |
| MIN_IFS Built-in MINIFS Returns the smallest numerical value that satisfies multiple conditions. |
| MIN_RANGE (Maths) |
| MINN MINNO add - Returns the highest N number of items |
| 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 Reverses a cell range |
| RANGE_SORT Built-in SORT Returns the array of data that has been sorted by one column. |
| REMOVE_CHARACTERS (Text) |
| REMOVE_FIRST_N_CHAR (Text) |
| REMOVE_LAST_N_CHAR (Text) |
| REPEAT (Text) |
| REPTX |
| RETURNCOLUMNS |
| REVERSE_TEXT REVERSE Returns the characters of a text string in reverse. |
| REVERSE_WORDS REVERSE Returns the characters of a text string in reverse. |
| RGB2HEX |
| RGB2HSL |
| RGB2HSV |
| RIGHT_FIND (Text) |
| RIGHT_SEARCH (Text) |
| RIGHT_SPLIT (Text) |
| RTOTAL |
| SEQUENCER |
| SHEET_CODE_NAME |
| SHEET_NAME WORKSHEETNAME Returns the name of the worksheet in a given position. |
| 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 Built-in CONCAT Returns the text string that is a concatenation of cell ranges and strings. |
| TEXT_LEFT (Text) |
| TEXTCLEAN (Text) |
| TEXTIFS |
| TIMECARD (Date & Time) |
| TIME-CONVERTER (Date & Time) |
| TOTALCOL |
| TOTALROW |
| TRIM_RIGHT (Text) |
| UNIQUE_365 Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| USER_NAME USERNAME Returns the application's user name or the domain username. |
| UTEXT (Maths) |
| VRNG |
| WB_AUTHOR WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_CATEGORY WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_COMMENTS WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_COMPANY WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_CREATION_DATE WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_KEYWORDS WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_LAST_AUTHOR WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_LAST_SAVE_TIME WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_MANAGER WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_SUBJECT WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WB_TITLE WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook. |
| WEEK_OF_MONTH (Date & Time) |
| WEEKDAY_NAME (Date & Time) |
| WEEKENDDATE ISWEEKEND add |
| WORDFREQ (Text) |
| WORKTIME (Date & Time) |
| XDATE (Date & Time) |
| YYWW_TO_DATE (Date & Time) |
| YYYYMMDD_TO_DATE (Date & Time) |
| ZFILL (Text) |
KuTools
| Library Function | Description |
| AVERAGEVISIBLE | AVERAGEVISIBLE Average visible cells, rows, or columns. |
| COUNTBYCELLCOLOR | COUNTFORMAT Count number of cells by a certain fill colour |
| COUNTBYFONTBOLD | COUNTFORMAT Count the number of only bold cells in a range |
| COUNTBYFONTCOLOR | COUNTFORMAT Count number of cells by a certain font colour |
| COUNTCHAR | COUNTSUBSTRING Count the occurrences of a character in a string |
| COUNTSHADES | COUNTFORMAT Counting numbers of cells which have been filled with colour |
| COUNTVISIBLE | COUNTVISIBLE Count visible cells, rows, or columns only |
| EXTRACTNUMBERS | EXTRACTNUMBERS Extract numbers from mixed text string with the function |
| REVERSETEXT | REVERSE Reverse order of characters in a cell with functions |
| SUMBYCELLCOLOR | SUMFORMAT Sum cells by a certain fill colour |
| SUMBYFONTBOLD | SUMFORMAT Sum bold values / numbers only |
| SUMBYFONTCOLOR | SUMFORMAT Sum cells by a certain font colour |
| SUMVISIBLE | SUMVISIBLE Sum visible cells, rows, or columns only |
| TIME2HOURS | CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal hours |
| TIME2MINUTES | CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal minutes |
| TIME2SECONDS | CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal seconds |
| 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 | SPELLNUMBER Returns the text after converting a number into words. |
| 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 | Built-in TRANSLATE Translate text between languages |
| Library Function Description |
| AVERAGEVISIBLE AVERAGEVISIBLE Average visible cells, rows, or columns. |
| COUNTBYCELLCOLOR COUNTFORMAT Count number of cells by a certain fill colour |
| COUNTBYFONTBOLD COUNTFORMAT Count the number of only bold cells in a range |
| COUNTBYFONTCOLOR COUNTFORMAT Count number of cells by a certain font colour |
| COUNTCHAR COUNTSUBSTRING Count the occurrences of a character in a string |
| COUNTSHADES COUNTFORMAT Counting numbers of cells which have been filled with colour |
| COUNTVISIBLE COUNTVISIBLE Count visible cells, rows, or columns only |
| EXTRACTNUMBERS EXTRACTNUMBERS Extract numbers from mixed text string with the function |
| REVERSETEXT REVERSE Reverse order of characters in a cell with functions |
| SUMBYCELLCOLOR SUMFORMAT Sum cells by a certain fill colour |
| SUMBYFONTBOLD SUMFORMAT Sum bold values / numbers only |
| SUMBYFONTCOLOR SUMFORMAT Sum cells by a certain font colour |
| SUMVISIBLE SUMVISIBLE Sum visible cells, rows, or columns only |
| TIME2HOURS CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal hours |
| TIME2MINUTES CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal minutes |
| TIME2SECONDS CONVERTTIME Convert "hh:mm:ss" formatting time or text to decimal seconds |
| 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 SPELLNUMBER Returns the text after converting a number into words. |
| 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 Built-in TRANSLATE Translate text between languages |
link - extendoffice.com/product/kutools-for-excel/excel-sum-count-average-visible-cells-only.html
MoreFunc
| 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 | Built-in UNIQUE Number of unique values in a range or array |
| COUNTIF.3D | Built-in COUNTIFS Returns the number of numerical values that satisfies multiple conditions. |
| DATE.DIFF | AGE Returns an age in years, months and days |
| EASTERDATE | Date of Easter Sunday for a given year |
| EVAL | Evaluates a formula or expression |
| FILENAME | WORKBOOKFILENAME Name of the workbook. |
| FORMULATEXT | FORMULATEXT Returns the formula of a cell. |
| GEOMEAN.EXT | Built-in GEOMEAN |
| 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 | Built-in SORT Sorts a range or an array (supports up to 14 sort keys) |
| HSORT.IDX | Sort index of a range or array (supports up to 14 sort keys) - vertical |
| INDIRECT.EXT | Built-in VSTACK Returns the array after putting multiple arrays on top of each other. |
| INTVECTOR | Returns a vector of consecutive integers in the ascending order |
| ISO.WEEKNUM | Built-in ISOWEEKNUM ISO-compliant week number of a day. |
| LASTROW | LASTINROW Last filled cell in a column. |
| MATRIXROUND | Adjusts an array of rounded numbers (=>sum of percentages = always 100%) |
| MCONCAT | Concatenates all values in a range or an array |
| MDETERM.EXT | Built-in MDETERM Returns the matrix determinant of an array. |
| MINVERSE.EXT | Built-in MINVERSE Returns the inverse matrix of an array. |
| 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 | Built-in MMULT Returns the matrix product of two 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 | WORKSHEETNAME Name of a sheet in the workbook. |
| 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 | REVERSE Reverses the characters of a string. |
| 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 | Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| VAR.GROUPED | Variance based on a sample (data grouped in classes) |
| VARP.GROUPED | Variance based on the entire population (grouped data) |
| VSORT | Built-in SORT Sorts a range or an array (supports up to 14 sort keys) |
| 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 | WORDCOUNT Number of words in a text |
| 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 Built-in UNIQUE Number of unique values in a range or array |
| COUNTIF.3D Built-in COUNTIFS Returns the number of numerical values that satisfies multiple conditions. |
| DATE.DIFF AGE Returns an age in years, months and days |
| EASTERDATE Date of Easter Sunday for a given year |
| EVAL Evaluates a formula or expression |
| FILENAME WORKBOOKFILENAME Name of the workbook. |
| FORMULATEXT FORMULATEXT Returns the formula of a cell. |
| GEOMEAN.EXT Built-in GEOMEAN |
| 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 Built-in SORT Sorts a range or an array (supports up to 14 sort keys) |
| HSORT.IDX Sort index of a range or array (supports up to 14 sort keys) - vertical |
| INDIRECT.EXT Built-in VSTACK Returns the array after putting multiple arrays on top of each other. |
| INTVECTOR Returns a vector of consecutive integers in the ascending order |
| ISO.WEEKNUM Built-in ISOWEEKNUM ISO-compliant week number of a day. |
| LASTROW LASTINROW Last filled cell in a column. |
| MATRIXROUND Adjusts an array of rounded numbers (=>sum of percentages = always 100%) |
| MCONCAT Concatenates all values in a range or an array |
| MDETERM.EXT Built-in MDETERM Returns the matrix determinant of an array. |
| MINVERSE.EXT Built-in MINVERSE Returns the inverse matrix of an array. |
| 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 Built-in MMULT Returns the matrix product of two 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 WORKSHEETNAME Name of a sheet in the workbook. |
| 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 REVERSE Reverses the characters of a string. |
| 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 Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| VAR.GROUPED Variance based on a sample (data grouped in classes) |
| VARP.GROUPED Variance based on the entire population (grouped data) |
| VSORT Built-in SORT Sorts a range or an array (supports up to 14 sort keys) |
| 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 WORDCOUNT Number of words in a text |
OzGrid
| Library Function | Description |
| AUTOFILTER_CRITERIA | |
| CALCULATIONMODE | |
| CALCULATIONSTATE | |
| CELLCOLOR | FORMATGET Returns a specific formatting attribute from a particular cell. |
| COLORRANK | FORMATGET Returns a specific formatting attribute from a particular cell. |
| CONVERTCURRENCYTOENGLISH | |
| COUNT_ONCE | COUNTUNIQUE Returns the number of unique values in a particular range. |
| COUNTWORDS | WORDCOUNT* Returns the number of words in a string |
| FINDNTH | |
| FIVE_CON_VLOOKUP | |
| FOUR_CON_VLOOKUP | |
| GET_WORD | WORDNO |
| GETADDRESS | HYPERLINKGET Returns the hyperlink associated with a particular cell. |
| GETCOMMENTTEXT | COMMENTGET Returns the comment associated with a particular cell. |
| GETFILENAME | WORKBOOKFILENAME Returns the file name of the active workbook. |
| GETMAXBETWEEN | MAXBETWEEN* Returns the largest value that is between a range. |
| HOWMANYDAYSINMONTH | DAYSINAMONTH Returns the number of days in a month and year. |
| ISFORMULA | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| LASTDAYOFMONTH | DATELAST* |
| LOOKUP_OCCURRENCE | |
| MYFULLNAME | WORKBOOKPATHFILENAME Returns the folder path and file name of the active workbook. |
| MYNAME | USERNAME Returns the application's user name or the domain username. |
| NTHDAYOFMONTH | |
| OZGRIDLOOKUP | |
| RANDLOTTO | RANDOMNUMBER* Returns random numbers between the two bounds. |
| RETURNLASTWORD | WORDNO-LAST |
| REVERSECELL | REVERSE Returns the contents of a particular cell with all the characters reversed. |
| SHEETNAME | WORKSHEETNAME |
| SPELLNUMBER | SPELLNUMBER Returns the text after converting a number into words. |
| SUMEVERYNTH | |
| THREE_CON_VLOOKUP | |
| TWO_CON_VLOOKUP | |
| VLOOKALLSHEETS | Built-in VLOOKUP Returns the value in the same row after finding a matching value in the first column. |
| WORKBOOKEXISTS | FILEEXISTS Returns whether a particular file exists. |
| Library Function Description |
| AUTOFILTER_CRITERIA |
| CALCULATIONMODE |
| CALCULATIONSTATE |
| CELLCOLOR FORMATGET Returns a specific formatting attribute from a particular cell. |
| COLORRANK FORMATGET Returns a specific formatting attribute from a particular cell. |
| CONVERTCURRENCYTOENGLISH |
| COUNT_ONCE COUNTUNIQUE Returns the number of unique values in a particular range. |
| COUNTWORDS WORDCOUNT* Returns the number of words in a string |
| FINDNTH |
| FIVE_CON_VLOOKUP |
| FOUR_CON_VLOOKUP |
| GET_WORD WORDNO |
| GETADDRESS HYPERLINKGET Returns the hyperlink associated with a particular cell. |
| GETCOMMENTTEXT COMMENTGET Returns the comment associated with a particular cell. |
| GETFILENAME WORKBOOKFILENAME Returns the file name of the active workbook. |
| GETMAXBETWEEN MAXBETWEEN* Returns the largest value that is between a range. |
| HOWMANYDAYSINMONTH DAYSINAMONTH Returns the number of days in a month and year. |
| ISFORMULA Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| LASTDAYOFMONTH DATELAST* |
| LOOKUP_OCCURRENCE |
| MYFULLNAME WORKBOOKPATHFILENAME Returns the folder path and file name of the active workbook. |
| MYNAME USERNAME Returns the application's user name or the domain username. |
| NTHDAYOFMONTH |
| OZGRIDLOOKUP |
| RANDLOTTO RANDOMNUMBER* Returns random numbers between the two bounds. |
| RETURNLASTWORD WORDNO-LAST |
| REVERSECELL REVERSE Returns the contents of a particular cell with all the characters reversed. |
| SHEETNAME WORKSHEETNAME |
| SPELLNUMBER SPELLNUMBER Returns the text after converting a number into words. |
| SUMEVERYNTH |
| THREE_CON_VLOOKUP |
| TWO_CON_VLOOKUP |
| VLOOKALLSHEETS Built-in VLOOKUP Returns the value in the same row after finding a matching value in the first column. |
| WORKBOOKEXISTS FILEEXISTS Returns whether a particular file exists. |
Power User Software
| Library Function | Description |
| CAGR | Returns the Compound Annual Growth Rate between 2 values for a given number of years. |
| CONCATENATE_RANGE | Built-in CONCAT Returns the concatenation of all cells within the defined range. |
| COUNTCOLOR | COUNTFORMAT Returns the number of cells in the selected range that have the same fill color as the reference cell. |
| COUNTUNIQUE | COUNTUNIQUE Returns the number of unique values in a particular range. |
| COUNTVISIBLE | COUNTVISIBLE Returns the number of visible cells in the reference range. |
| COUNTWORDS | WORDCOUNT* Returns the number or words in a range that contains text. |
| HASFORMULAS | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| 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 | 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 | LASTINCOLUMN Returns the number of the last column (bottom right) in the defined sheet |
| LASTROWNUMBER | LASTINROW 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 | RANGEEXISTS add - 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 | WORKSHEETNAME Returns the name of the sheet that contains the reference cell. |
| SLICERITEMS | Returns the list of items selected in the defined slicer. |
| SUMCOLOR | SUMFORMAT 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 | WEIGHTEDAVERAGE Returns the average of values in a column weighted by the values in another column. |
| WORD_N | WORDGET* Returns the n-th word from a text. |
| Library Function Description |
| CAGR Returns the Compound Annual Growth Rate between 2 values for a given number of years. |
| CONCATENATE_RANGE Built-in CONCAT Returns the concatenation of all cells within the defined range. |
| COUNTCOLOR COUNTFORMAT Returns the number of cells in the selected range that have the same fill color as the reference cell. |
| COUNTUNIQUE COUNTUNIQUE Returns the number of unique values in a particular range. |
| COUNTVISIBLE COUNTVISIBLE Returns the number of visible cells in the reference range. |
| COUNTWORDS WORDCOUNT* Returns the number or words in a range that contains text. |
| HASFORMULAS Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| 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 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 LASTINCOLUMN Returns the number of the last column (bottom right) in the defined sheet |
| LASTROWNUMBER LASTINROW 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 RANGEEXISTS add - 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 WORKSHEETNAME Returns the name of the sheet that contains the reference cell. |
| SLICERITEMS Returns the list of items selected in the defined slicer. |
| SUMCOLOR SUMFORMAT 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 WEIGHTEDAVERAGE Returns the average of values in a column weighted by the values in another column. |
| WORD_N WORDGET* Returns the n-th word from a text. |
link - support.powerusersoftware.com/ support/solutions/articles/80001023454-advanced-excel-functions
Power Utility Pack
| Library Function | Description |
| AGE | AGE Calculate the age based on a date of birth. |
| CELLCOLOR | FORMATGET Returns a specific formatting attribute from a particular cell. |
| CELLHASFORMULA | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| CELLTYPE | CELLTYPE* |
| CHAR2 | Built-in UNICODE Returns the unicode number for the first character in a text string. |
| CODE2 | Built-in UNICHAR Returns the character with the corresponding UNICODE character. |
| CONTAINS | CONTAINS Returns whether a string is contained inside another string. |
| COUNTAVISIBLE | COUNTVISIBLEA* |
| COUNTBETWEEN | COUNTBETWEEN Counts the number of values in a range that fall between two values. |
| COUNTBYCOLOR | COUNTFORMAT Counts the cells based on fill colour. |
| COUNTVISIBLE | COUNTVISIBLE Counts the visible cells. |
| CREDITCARD | Returns a randomly generated valid-looking credit card number (2546 5635 8563 5747) |
| DAYSINMONTH | DAYSINAMONTH Returns the number of days in a month. |
| DOLLORTEXT | SPELLNUMBER Returns the text after converting a number into words. |
| EXCELDIR | EXCELDIR* |
| EXTRACTELEMENT | WORDGET* Returns the nth element of a string that uses a separator character. |
| FILEEXISTS | FILEEXISTS Returns whether a particular file exists. |
| FILENAME | WORKBOOKFILENAME Returns the file name of the active workbook. |
| FONTCOLOR | FORMATGET Returns a specific formatting attribute from a particular cell. |
| 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 | ISBETWEEN* Returns the boolean True or False depending if the value lies between two bounds. |
| ISERRORTYPE | Returns specific error codes. |
| ISFORMULA | Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| ISINRANGE | Returns TRUE if a value exists anyway inside a range. |
| ISLIKE | ISLIKE* Returns whether a particular string matches a certain pattern. |
| LASTINCOLUMN | LASTINCOLUMN Returns the last cell that contains data in a particular column. |
| LASTINROW | LASTINROW Returns the last cell that contains data in a particular row. |
| MAXALLSHEETS | ALLSHEETS* Returns the maximum value in a particular cell across all worksheets in a workbook. |
| MINALLSHEETS | ALLSHEETS* Returns the minimum value in a particular cell across all worksheets in a workbook. |
| MONTHWEEK | WEEKNUMBER* Returns the calendar week for a date serial number |
| NUMBERFORMAT | NUMBERFORMATGET |
| NTHINSTANCE | Find the nth occurrence of a substring. |
| NTHWORD | Extract the nth word. |
| ORDINAL | 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 | Built-in PROPER 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 | RANDOMNUMBER* Returns random number with constraints. |
| REMOVESPACES | REMOVESPACES* Removes all the spaces from a text string. |
| SAYIT | Used to speak the text that was in a cell by using the Windows SAPI voice. |
| SCRAMBLE | SCRAMBLE Returns the characters of a text string with all the characters in a random order. |
| SELECTONE | SELECTONE* |
| SHEETCOUNT | Built-in SHEETS Returns the number of sheets in a reference. |
| SHEETNAME | WORKSHEETNAME Returns the name of the worksheet in a given position. |
| SHEETOFFSET | SHEETOFFSET* |
| STATICRAND | Built-in RANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. |
| SUMALLSHEETS | ALLSHEETS* Returns the sum of all values in a particular cell across all worksheets in a workbook. |
| SUMBYCOLOR | SUMFORMAT Returns the sum of the values based on cell colour. |
| SUMVISIBLE | SUMVISIBLE Similar to Excel's SUM function, but it returns the SUM of just the visible cells. |
| 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 | AVERAGETOP* Returns the average of the top n values in a list. |
| UNIQUEITEMS | Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| USER | USERNAME Returns the application's user name or the domain username. |
| VINTERPOLATE | Strict linear interpolation between two known X-values down a column. Supporting exact match and between match. |
| VLOOKUPEXACT | Built-in VLOOKUP Returns the value in the same row after finding a matching value in the first column. |
| 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 AGE Calculate the age based on a date of birth. |
| CELLCOLOR FORMATGET Returns a specific formatting attribute from a particular cell. |
| CELLHASFORMULA Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| CELLTYPE CELLTYPE* |
| CHAR2 Built-in UNICODE Returns the unicode number for the first character in a text string. |
| CODE2 Built-in UNICHAR Returns the character with the corresponding UNICODE character. |
| CONTAINS CONTAINS Returns whether a string is contained inside another string. |
| COUNTAVISIBLE COUNTVISIBLEA* |
| COUNTBETWEEN COUNTBETWEEN Counts the number of values in a range that fall between two values. |
| COUNTBYCOLOR COUNTFORMAT Counts the cells based on fill colour. |
| COUNTVISIBLE COUNTVISIBLE Counts the visible cells. |
| CREDITCARD Returns a randomly generated valid-looking credit card number (2546 5635 8563 5747) |
| DAYSINMONTH DAYSINAMONTH Returns the number of days in a month. |
| DOLLORTEXT SPELLNUMBER Returns the text after converting a number into words. |
| EXCELDIR EXCELDIR* |
| EXTRACTELEMENT WORDGET* Returns the nth element of a string that uses a separator character. |
| FILEEXISTS FILEEXISTS Returns whether a particular file exists. |
| FILENAME WORKBOOKFILENAME Returns the file name of the active workbook. |
| FONTCOLOR FORMATGET Returns a specific formatting attribute from a particular cell. |
| 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 ISBETWEEN* Returns the boolean True or False depending if the value lies between two bounds. |
| ISERRORTYPE Returns specific error codes. |
| ISFORMULA Built-in ISFORMULA Returns the boolean True or False depending if the cell contains a formula. |
| ISINRANGE Returns TRUE if a value exists anyway inside a range. |
| ISLIKE ISLIKE* Returns whether a particular string matches a certain pattern. |
| LASTINCOLUMN LASTINCOLUMN Returns the last cell that contains data in a particular column. |
| LASTINROW LASTINROW Returns the last cell that contains data in a particular row. |
| MAXALLSHEETS ALLSHEETS* Returns the maximum value in a particular cell across all worksheets in a workbook. |
| MINALLSHEETS ALLSHEETS* Returns the minimum value in a particular cell across all worksheets in a workbook. |
| MONTHWEEK WEEKNUMBER* Returns the calendar week for a date serial number |
| NUMBERFORMAT NUMBERFORMATGET |
| NTHINSTANCE Find the nth occurrence of a substring. |
| NTHWORD Extract the nth word. |
| ORDINAL 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 Built-in PROPER 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 RANDOMNUMBER* Returns random number with constraints. |
| REMOVESPACES REMOVESPACES* Removes all the spaces from a text string. |
| SAYIT Used to speak the text that was in a cell by using the Windows SAPI voice. |
| SCRAMBLE SCRAMBLE Returns the characters of a text string with all the characters in a random order. |
| SELECTONE SELECTONE* |
| SHEETCOUNT Built-in SHEETS Returns the number of sheets in a reference. |
| SHEETNAME WORKSHEETNAME Returns the name of the worksheet in a given position. |
| SHEETOFFSET SHEETOFFSET* |
| STATICRAND Built-in RANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. |
| SUMALLSHEETS ALLSHEETS* Returns the sum of all values in a particular cell across all worksheets in a workbook. |
| SUMBYCOLOR SUMFORMAT Returns the sum of the values based on cell colour. |
| SUMVISIBLE SUMVISIBLE Similar to Excel's SUM function, but it returns the SUM of just the visible cells. |
| 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 AVERAGETOP* Returns the average of the top n values in a list. |
| UNIQUEITEMS Built-in UNIQUE Returns the array of unique values in a list, table or cell range. |
| USER USERNAME Returns the application's user name or the domain username. |
| VINTERPOLATE Strict linear interpolation between two known X-values down a column. Supporting exact match and between match. |
| VLOOKUPEXACT Built-in VLOOKUP Returns the value in the same row after finding a matching value in the first column. |
| 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* |
Professor Excel
| Library Function | Description |
| AUTHOR | WORKBOOKPROPERTIES Returns the author, who has initially created the workbook. |
| BACKGROUNDCOLOR | FORMATGET Returns the background color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| CELLFORMATCODEFUNCTION | Returns the exact format code from a cell. |
| COLUMN | COLUMNLETTER add - Returns the column letter (not number) of a cell. |
| COMMENTAUTHORNAME | Returns the name of the person who added the initial comment (new in Excel 365). |
| COMMENTREPLYAUTHORNAME | Returns the name of the person who added the n-th comment (new in Excel 365). |
| COMMENTREPLY | Returns the text of a reply comment (new in Excel 365). The older comments in Excel are called notes now. |
| COMMENTTEXT | Returns the text of a threaded comment (new in Excel 365). |
| DATECREATED | WORKBOOKPROPERTIES Returns the date on which the workbook was created. |
| DATELASTSAVED | WORKBOOKPROPERTIES Returns the date on which the workbook was saved the last time. |
| FILENAME | Returns the filename of a cell. |
| FILESIZE | Returns the file size of the workbook. |
| FOLDERNAME | Returns the name of the folder in which the workbook is saved in. |
| FONTCOLOR | FORMATGET Returns the font color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| HASSTRIKETHROUGH | Returns TRUE if the cell is formatted with strikethrough and FALSE if the cell is not formatted with strikethrough. |
| HYPERLINKADDRESS | Returns the hyperlink of a cell if available. |
| INDENTLEVEL | FORMATGET Returns the indentation of a cell. |
| ISVISIBLE | Returns TRUE if the cell is visible. If the row or column is hidden, grouped or filtered, this returns FALSE. |
| LASTSAVEDBY | WORKBOOKPROPERTIES Returns the name of the person who saved the workbook the last time. |
| MAXIF | Built-in MAXIFS Returns the maximum value of a cell range depending on a criteria in another cell range. |
| MINIF | Built-in MINIFS Returns the minimum value of a cell range depending on a criteria in another cell range. |
| NOTETEXT | Returns the text of a note (original comment, not the new threaded comments in Excel 365). |
| NUMBEROFHIDDENWORKSHEETS | COUNTHIDDENSHEETS Returns the number of hidden worksheets. |
| NUMBEROFWORKSHEETS | Built-in SHEETS The total number of worksheets. |
| REPLY | Returns the text of a reply comment |
| REPLYAUTHORNAME | Returns the name of the person who added the nth comment |
| SHEETNAME | WORKSHEETNAME Returns the name of the worksheet this cell is on. |
| TEXT | Returns the text of a threaded comment |
| WEEKDAYNAME | WEEKDAYNAME add - Returns the name of the weekday in English. |
| WORKBOOKPATH | WORKBOOKPATH Returns the path of the workbook. |
| Library Function Description |
| AUTHOR WORKBOOKPROPERTIES Returns the author, who has initially created the workbook. |
| BACKGROUNDCOLOR FORMATGET Returns the background color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| CELLFORMATCODEFUNCTION Returns the exact format code from a cell. |
| COLUMN COLUMNLETTER add - Returns the column letter (not number) of a cell. |
| COMMENTAUTHORNAME Returns the name of the person who added the initial comment (new in Excel 365). |
| COMMENTREPLYAUTHORNAME Returns the name of the person who added the n-th comment (new in Excel 365). |
| COMMENTREPLY Returns the text of a reply comment (new in Excel 365). The older comments in Excel are called notes now. |
| COMMENTTEXT Returns the text of a threaded comment (new in Excel 365). |
| DATECREATED WORKBOOKPROPERTIES Returns the date on which the workbook was created. |
| DATELASTSAVED WORKBOOKPROPERTIES Returns the date on which the workbook was saved the last time. |
| FILENAME Returns the filename of a cell. |
| FILESIZE Returns the file size of the workbook. |
| FOLDERNAME Returns the name of the folder in which the workbook is saved in. |
| FONTCOLOR FORMATGET Returns the font color of a cell. You can choose, if you want to get the RGB or the Excel Color Index number. |
| HASSTRIKETHROUGH Returns TRUE if the cell is formatted with strikethrough and FALSE if the cell is not formatted with strikethrough. |
| HYPERLINKADDRESS Returns the hyperlink of a cell if available. |
| INDENTLEVEL FORMATGET Returns the indentation of a cell. |
| ISVISIBLE Returns TRUE if the cell is visible. If the row or column is hidden, grouped or filtered, this returns FALSE. |
| LASTSAVEDBY WORKBOOKPROPERTIES Returns the name of the person who saved the workbook the last time. |
| MAXIF Built-in MAXIFS Returns the maximum value of a cell range depending on a criteria in another cell range. |
| MINIF Built-in MINIFS Returns the minimum value of a cell range depending on a criteria in another cell range. |
| NOTETEXT Returns the text of a note (original comment, not the new threaded comments in Excel 365). |
| NUMBEROFHIDDENWORKSHEETS COUNTHIDDENSHEETS Returns the number of hidden worksheets. |
| NUMBEROFWORKSHEETS Built-in SHEETS The total number of worksheets. |
| REPLY Returns the text of a reply comment |
| REPLYAUTHORNAME Returns the name of the person who added the nth comment |
| SHEETNAME WORKSHEETNAME Returns the name of the worksheet this cell is on. |
| TEXT Returns the text of a threaded comment |
| WEEKDAYNAME WEEKDAYNAME add - Returns the name of the weekday in English. |
| WORKBOOKPATH WORKBOOKPATH Returns the path of the workbook. |
link - professor-excel.com/ features-of-professor-excel-tools-in-detail/
XLTools
| Library Function | Description |
| COMPUTEMD5HASH | Encodes a text string to an MD5 hash |
| CONCATENATE | Built-in CONCAT Concatenates all values in a range into a single string with any separator |
| COUNTWORDS | WORDCOUNT* 'Counts the number of words in a range |
| DATEADD | Adds years, quarters, months, days, minutes, hours and seconds to a date |
| DATETOTICKS | Converts date and time values into the number of ticks |
| FINDEMAIL | Finds and extracts an email address from a text string |
| FINDNUMBER | Finds and extracts a number from a text string |
| FORMATDATE | Changes format of date and time values |
| FORMATPHONENUMBER | Formats a string as a phone number |
| HEXCOLORTORGB | Converts Hex color code to RGB format |
| RANDOM | Generates an array of random numbers, including unique random numbers |
| STRINGFORMAT | Creates text strings with dynamically filled placeholders |
| Library Function Description |
| COMPUTEMD5HASH Encodes a text string to an MD5 hash |
| CONCATENATE Built-in CONCAT Concatenates all values in a range into a single string with any separator |
| COUNTWORDS WORDCOUNT* 'Counts the number of words in a range |
| DATEADD Adds years, quarters, months, days, minutes, hours and seconds to a date |
| DATETOTICKS Converts date and time values into the number of ticks |
| FINDEMAIL Finds and extracts an email address from a text string |
| FINDNUMBER Finds and extracts a number from a text string |
| FORMATDATE Changes format of date and time values |
| FORMATPHONENUMBER Formats a string as a phone number |
| HEXCOLORTORGB Converts Hex color code to RGB format |
| RANDOM Generates an array of random numbers, including unique random numbers |
| STRINGFORMAT Creates text strings with dynamically filled placeholders |
link - https://xltools.net/xl-functions/
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext