Migration


ASAP Utilities Functions

link - asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=259

Library FunctionDescription
ASAPCELLCOLORINDEXReturns the color index number of the cell. FORMATGET
ASAPCOUNTBYCELLCOLORCounts the number of cells in the given range that have a certain fill color. COUNTFORMAT
ASAPCOUNTBYFONTCOLORCounts the number of cells in the given range that have a certain font color. COUNTFORMAT
ASAPCOUNTCHARCounts the number of times a character occurs in a text. COUNTSUBSTRING
ASAPCOUNTSHADESCounts the number of colored cells in your range. COUNTFORMAT
ASAPEXTRACTFILENAMEReturns the file name from a full path and filename. EXTRACTFILENAME
ASAPEXTRACTFOLDERNAMEReturns the folder name from a combined filepath and filename. EXTRACTFOLDERPATH
ASAPEXTRACTNUMBERSReturns the numbers from a text string. EXTRACTNUMBERS
ASAPFILENAMEReturns the name of your workbook. WORKBOOKFILENAME
ASAPFILEPATHReturns the filepath (the folder) where your workbook is stored. WORKBOOKPATH
ASAPFILEPROPERTIESReturns the value of one of the built-in document properties for the current workbook. WORKBOOKPROPERTIES
ASAPFONTCOLORINDEXReturns the color index number of the font of a cell. FORMATGET
ASAPFULLFILENAMEReturns the full filename of your workbook. WORKBOOKPATHFILENAME
ASAPGETCOMMENTReturns the text from the comment a cell. COMMENTGET
ASAPGETDOMAINReturns the (sub)domain from a given hyperlink (website address/url). HYPERLINKGET
ASAPGETFONTNAMEReturns the name of the font in a cell. FORMATGET
ASAPGETFONTSIZEReturns the font size of a cell. FORMATGET
ASAPGETFORMULAFORMULATEXT added in 2013 to the Lookup & Reference category.
Returns the formula from a particular cell.
ASAPGETFORMULAINTReturns the formula of a cell in the "international" notation.
ASAPGETHYPERLINKReturns the hyperlink from a cell. HYPERLINKGET
ASAPGETNUMBERFORMATReturns the number format of a cell. NUMBERFORMATGET
ASAPISBOLDReturns TRUE if the cell is bold or FALSE if it isn't. ISBOLD
ASAPISFORMULAISFORMULA added in 2013 to the Information category
Returns TRUE if the cell has a formula or FALSE if it doesn't.
ASAPLOADIMAGEInserts the specified image as an object and puts it at the left-top of your cell. IMAGEDISPLAY
ASAPMERGECELLSJoins several text strings into one text string. MERGECELLS
ASAPRANDOMPASSWORDReturns a random string that can be used as a password. RANDOMPASSWORD
ASAPSHEETNAMEReturns the name of the worksheet this formula is used on. WORKSHEETNAME
ASAPSPELLNUMBERReturns a spelled-out number or amount. SPELLNUMBER
ASAPSTRIPNUMBERSRemoves all numbers from a text string and removes all spaces at the beginning and end of the result. REMOVENUMBERS
ASAPSUMBYCELLCOLORAdds the cells that have a certain fill color. SUMFORMAT
ASAPSUMBYFONTCOLORAdds the cells that have a certain font color. SUMFORMAT
Library Function
Description
ASAPCELLCOLORINDEX
Returns the color index number of the cell. FORMATGET
ASAPCOUNTBYCELLCOLOR
Counts the number of cells in the given range that have a certain fill color. COUNTFORMAT
ASAPCOUNTBYFONTCOLOR
Counts the number of cells in the given range that have a certain font color. COUNTFORMAT
ASAPCOUNTCHAR
Counts the number of times a character occurs in a text. COUNTSUBSTRING
ASAPCOUNTSHADES
Counts the number of colored cells in your range. COUNTFORMAT
ASAPEXTRACTFILENAME
Returns the file name from a full path and filename. EXTRACTFILENAME
ASAPEXTRACTFOLDERNAME
Returns the folder name from a combined filepath and filename. EXTRACTFOLDERPATH
ASAPEXTRACTNUMBERS
Returns the numbers from a text string. EXTRACTNUMBERS
ASAPFILENAME
Returns the name of your workbook. WORKBOOKFILENAME
ASAPFILEPATH
Returns the filepath (the folder) where your workbook is stored. WORKBOOKPATH
ASAPFILEPROPERTIES
Returns the value of one of the built-in document properties for the current workbook. WORKBOOKPROPERTIES
ASAPFONTCOLORINDEX
Returns the color index number of the font of a cell. FORMATGET
ASAPFULLFILENAME
Returns the full filename of your workbook. WORKBOOKPATHFILENAME
ASAPGETCOMMENT
Returns the text from the comment a cell. COMMENTGET
ASAPGETDOMAIN
Returns the (sub)domain from a given hyperlink (website address/url). HYPERLINKGET
ASAPGETFONTNAME
Returns the name of the font in a cell. FORMATGET
ASAPGETFONTSIZE
Returns the font size of a cell. FORMATGET
ASAPGETFORMULA
FORMULATEXT added in 2013 to the Lookup & Reference category.
Returns the formula from a particular cell.
ASAPGETFORMULAINT
Returns the formula of a cell in the "international" notation.
ASAPGETHYPERLINK
Returns the hyperlink from a cell. HYPERLINKGET
ASAPGETNUMBERFORMAT
Returns the number format of a cell. NUMBERFORMATGET
ASAPISBOLD
Returns TRUE if the cell is bold or FALSE if it isn't. ISBOLD
ASAPISFORMULA
ISFORMULA added in 2013 to the Information category
Returns TRUE if the cell has a formula or FALSE if it doesn't.
ASAPLOADIMAGE
Inserts the specified image as an object and puts it at the left-top of your cell. IMAGEDISPLAY
ASAPMERGECELLS
Joins several text strings into one text string. MERGECELLS
ASAPRANDOMPASSWORD
Returns a random string that can be used as a password. RANDOMPASSWORD
ASAPSHEETNAME
Returns the name of the worksheet this formula is used on. WORKSHEETNAME
ASAPSPELLNUMBER
Returns a spelled-out number or amount. SPELLNUMBER
ASAPSTRIPNUMBERS
Removes all numbers from a text string and removes all spaces at the beginning and end of the result. REMOVENUMBERS
ASAPSUMBYCELLCOLOR
Adds the cells that have a certain fill color. SUMFORMAT
ASAPSUMBYFONTCOLOR
Adds the cells that have a certain font color. SUMFORMAT

KuTools Functions

Link - extendoffice.com/product/kutools-for-excel/product-tutorials.html

Library FunctionDescription
AVERAGEVISIBLEAverage Visible cells: Easily average visible cells, rows, or columns AVERAGEVISIBLE
COUNTBYCELLCOLORCount by cell color: Count number of cells by a certain fill color COUNTFORMAT
COUNTBYFONTCOLORCount by font color: Count number of cells by a certain font color COUNTFORMAT
COUNTBYFONTBOLDCount by font bold: Easily count the number of only bold cells in a range COUNTFORMAT
COUNTCHARCount characters: Quickly count the occurrences of a character in a string COUNTSUBSTRING
COUNTSHADESCount shades: Counting numbers of cells which have been filled with color COUNTFORMAT
COUNTVISIBLECount Visible Cells: Easily count visible cells, rows, or columns only COUNTVISIBLE
SUMBYCELLCOLORSum by cell color: Sum cells by a certain fill color SUMFORMAT
SUMBYFONTCOLORSum by font color: Sum cells by a certain font color SUMFORMAT
SUMBYFONTBOLDSum by font bold: Quickly sum bold values / numbers only SUMFORMAT
SUMVISIBLESum Visible Cells: Easily sum visible cells, rows, or columns only SUMVISIBLE
EXTRACTNUMBERSExtract Numbers: Extract numbers from mixed text string with the function EXTRACTNUMBERS
REVERSETEXTReverse Text: Easily reverse order of characters in a cell with functions REVERSE
TIME2HOURSConvert "hh:mm:ss" formatting time or text to decimal hours CONVERTTIME
TIME2MINUTESConvert "hh:mm:ss" formatting time or text to decimal minutes CONVERTTIME
TIME2SECONDSConvert "hh:mm:ss" formatting time or text to decimal seconds CONVERTTIME
Library Function
Description
AVERAGEVISIBLE
Average Visible cells: Easily average visible cells, rows, or columns AVERAGEVISIBLE
COUNTBYCELLCOLOR
Count by cell color: Count number of cells by a certain fill color COUNTFORMAT
COUNTBYFONTCOLOR
Count by font color: Count number of cells by a certain font color COUNTFORMAT
COUNTBYFONTBOLD
Count by font bold: Easily count the number of only bold cells in a range 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
SUMBYCELLCOLOR
Sum by cell color: Sum cells by a certain fill color SUMFORMAT
SUMBYFONTCOLOR
Sum by font color: Sum cells by a certain font color SUMFORMAT
SUMBYFONTBOLD
Sum by font bold: Quickly sum bold values / numbers only SUMFORMAT
SUMVISIBLE
Sum Visible Cells: Easily sum visible cells, rows, or columns only SUMVISIBLE
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
TIME2HOURS
Convert "hh:mm:ss" formatting time or text to decimal hours CONVERTTIME
TIME2MINUTES
Convert "hh:mm:ss" formatting time or text to decimal minutes CONVERTTIME
TIME2SECONDS
Convert "hh:mm:ss" formatting time or text to decimal seconds CONVERTTIME

Power User Software

link - support.powerusersoftware.com/support/solutions/articles/80001023454-advanced-functions

Library FunctionDescription
RangeExistsChecks if a named range exists in the defined sheet.
ShapeExists 
SheetExistsChecks if a worksheet name exists in the active workbook.
LastCellReturns the value of the last cell (bottom right) in the defined sheet
LastCellAddressReturns the address of the last cell (bottom right) in the defined sheet
LastColumnNumberReturns the number of the last column (bottom right) in the defined sheet
LastRowNumberReturns the number of the last row (bottom right) in the defined sheet
SheetNameReturns the name of the sheet that contains the reference cell.
HasFormulasChecks if the reference cell has formulas.
IsMergedChecks if the reference cell is merged with other cells.
SumColorReturns the sum of cells in the selected range that have the same fill color as the reference cell.
CountColorReturns the number of cells in the selected range that have the same fill color as the reference cell.
SumFromAllSheetsReturns the sum of the values in the reference cell for all sheets in the active workbook.
CountUniqueReturns the number of unique values in the reference range.
CountVisibleReturns the number of visible cells in the reference range.
UsedRangeReturns the address of the range that is being used in the defined sheet.
CountWordsReturns the number or words in a range that contains text.
SlicerItemsReturns the list of items selected in the defined slicer.
Vlookup_MaxReturns the maximum value of all results that match lookup value.
Vlookup_MinReturns the minimum value of all results that match lookup value.
Hlookup_MaxReturns the maximum value of all results that match lookup value.
Hlookup_MinReturns the minimum value of all results that match lookup value.
CAGRReturns the Compound Annual Growth Rate between 2 values for a given number of years.
Word_nReturns the n-th word from a text.
Concatenate_RangeReturns the concatenation of all cells within the defined range.
Weighted_AverageReturns the average of values in a column weighted by the values in another column.
Percent_ChangeReturns the percentage that changes one value into another.
RMSReturns the Root Mean Square of a set of data.
Library Function
Description
RangeExists
Checks if a named range exists in the defined sheet.
ShapeExists
SheetExists
Checks if a worksheet name exists in the active workbook.
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
SheetName
Returns the name of the sheet that contains the reference cell.
HasFormulas
Checks if the reference cell has formulas.
IsMerged
Checks if the reference cell is merged with other cells.
SumColor
Returns the sum of cells in the selected range that have the same fill color as the reference cell.
CountColor
Returns the number 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.
CountUnique
Returns the number of unique values in the reference range.
CountVisible
Returns the number of visible cells in the reference range.
UsedRange
Returns the address of the range that is being used in the defined sheet.
CountWords
Returns the number or words in a range that contains text.
SlicerItems
Returns the list of items selected in the defined slicer.
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.
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.
CAGR
Returns the Compound Annual Growth Rate between 2 values for a given number of years.
Word_n
Returns the n-th word from a text.
Concatenate_Range
Returns the concatenation of all cells within the defined range.
Weighted_Average
Returns the average of values in a column weighted by the values in another column.
Percent_Change
Returns the percentage that changes one value into another.
RMS
Returns the Root Mean Square of a set of data.

Professor Excel

link - professor-excel.com/features-of-professor-excel-tools-in-detail/

Library FunctionDescription
PROFEXAuthor 
PROFEXBackgroundColor 
PROFEXCellFormatCodeFunction 
PROFEXColumnreturns the column letter
PROFEXCommentAuthorNamereturns the name of the person who added the initial comment
PROFEXDateCreated 
PROFEXDateLastSaved 
PROFEXFileSize 
PROFEXFolderPath 
PROFEXFontColor 
PROFEXHasStrikethrough 
PROFEXHyperlinkAddress 
PROFEXIndentLevel 
PROFEXIsVisible 
PROFEXLastSavedBy 
PROFEXMaxIf 
PROFEXMinIf 
PROFEXNoteText 
PROFEXNumberOfHiddenWorksheets 
PROFEXNumberOfWorksheetsbuilt-in functions SHEETS
PROFEXReplyreturns the text of a reply comment
PROFEXReplyAuthorNamereturns the name of the person who added the nth comment
PROFEXSheetName 
PROFEXTextreturns the text of a threaded comment
PROFEXWeekdayName 
PROFEXWorkbookPath 
Library Function
Description
PROFEXAuthor
PROFEXBackgroundColor
PROFEXCellFormatCodeFunction
PROFEXColumn
returns the column letter
PROFEXCommentAuthorName
returns the name of the person who added the initial comment
PROFEXDateCreated
PROFEXDateLastSaved
PROFEXFileSize
PROFEXFolderPath
PROFEXFontColor
PROFEXHasStrikethrough
PROFEXHyperlinkAddress
PROFEXIndentLevel
PROFEXIsVisible
PROFEXLastSavedBy
PROFEXMaxIf
PROFEXMinIf
PROFEXNoteText
PROFEXNumberOfHiddenWorksheets
PROFEXNumberOfWorksheets
built-in functions SHEETS
PROFEXReply
returns the text of a reply comment
PROFEXReplyAuthorName
returns the name of the person who added the nth comment
PROFEXSheetName
PROFEXText
returns the text of a threaded comment
PROFEXWeekdayName
PROFEXWorkbookPath

Power Utility Pack Functions

Library FunctionDescription
CellColorFORMATGET
CellHasFormulaISFORMULA added in Excel 2013 to the Information category.
Returns TRUE if the cell has a formula or FALSE if it doesn't.
CellTypeCELLTYPE
Char2UNICODE added in Excel 2013.
Code2UNICHAR added in Excel 2013
ContainsCONTAINS
CountAVisibleCOUNTAVISIBLE
CountBetweenCounts the number of values in a range that fall between two values. COUNTBETWEEN
CreditCard 
DaysInMonthReturns the number of days in a month. DAYSINAMONTH
DollorTextReturns its numeric argument, spelled out as dollars and cents text. SPELLNUMBER
ExcelDirEXCELDIR
ExtractElementReturns the nth element of a string that uses a separator character. WORDGET
FileExistsFILEEXISTS
FileNameWORKBOOKFILENAME
FontColorFORMATGET
HInterpolateHLOOKUPINTERPOLATE
InsertStringINSERTSTRING
IsLikeISLIKE
LastInColumnLASTINCOLUMN
LastInRowLASTINROW
MaxAllSheetsReturns the maximum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MAX
MinAllSheetsReturns the minimum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MIN
MonthWeekReturns the calendar week for a date serial number WEEKNUMBER
NumberFormatNUMBERFORMATGET
ParseNameSplits a string that contains a name into its component parts: first name, middle name, and last name
RemoveSpacesREMOVESPACES
SayIt 
ScrambleSCRAMBLE
SelectOneSELECTONE
SheetCountSHEETS added in Excel 2013.
SheetNameWORKSHEETNAME
SheetOffsetSHEETOFFSET
StaticRandRANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. RANDOMNUMBER
SumAllSheetsReturns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS
SumVisibleSimilar 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
TimeXXReturns a string that represents a time, displayed as hh:mm:ss:xx, where xx is hundredths of a second (or another unit)..
TimeXX_AddReturns a string that represents the sum of two TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TimeXX_SubtractReturns a string that represents the difference between two TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TimeXX_SumReturns a string that represents the sum TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TopAverageReturns the average of the top n values in a list. AVERAGETOP
UniqueItemsUNIQUE added in 2021.
UserUSERNAME
VInterpolateVLOOKUPINTERPOLATE
WhichDayReturns 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
XDateDATESBEFORE1900
XDate_AddDATESBEFORE1900
XDate_DayDATESBEFORE1900
XDate_DifDATESBEFORE1900
XDate_DowDATESBEFORE1900
XDATE_MonthDATESBEFORE1900
XDate_YearDATESBEFORE1900
XDate_YearDifDATESBEFORE1900
Library Function
Description
CellColor
FORMATGET
CellHasFormula
ISFORMULA added in Excel 2013 to the Information category.
Returns TRUE if the cell has a formula or FALSE if it doesn't.
CellType
CELLTYPE
Char2
UNICODE added in Excel 2013.
Code2
UNICHAR added in Excel 2013
Contains
CONTAINS
CountAVisible
COUNTAVISIBLE
CountBetween
Counts the number of values in a range that fall between two values. COUNTBETWEEN
CreditCard
DaysInMonth
Returns the number of days in a month. DAYSINAMONTH
DollorText
Returns its numeric argument, spelled out as dollars and cents text. SPELLNUMBER
ExcelDir
EXCELDIR
ExtractElement
Returns the nth element of a string that uses a separator character. WORDGET
FileExists
FILEEXISTS
FileName
WORKBOOKFILENAME
FontColor
FORMATGET
HInterpolate
HLOOKUPINTERPOLATE
InsertString
INSERTSTRING
IsLike
ISLIKE
LastInColumn
LASTINCOLUMN
LastInRow
LASTINROW
MaxAllSheets
Returns the maximum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MAX
MinAllSheets
Returns the minimum value in a particular cell across all worksheets in a workbook. ALLSHEETS_MIN
MonthWeek
Returns the calendar week for a date serial number WEEKNUMBER
NumberFormat
NUMBERFORMATGET
ParseName
Splits a string that contains a name into its component parts: first name, middle name, and last name
RemoveSpaces
REMOVESPACES
SayIt
Scramble
SCRAMBLE
SelectOne
SELECTONE
SheetCount
SHEETS added in Excel 2013.
SheetName
WORKSHEETNAME
SheetOffset
SHEETOFFSET
StaticRand
RANDARRAY. Returns a random number that doesn't change when the worksheet is recalculated. RANDOMNUMBER
SumAllSheets
Returns the sum of all values in a particular cell across all worksheets in a workbook. ALLSHEETS
SumVisible
Similar to Excel's SUM function, but it returns the SUM of just the visible cells. This function is well-suited for use with AutoFiltering and Outlining. SUMVISIBLE
TimeXX
Returns a string that represents a time, displayed as hh:mm:ss:xx, where xx is hundredths of a second (or another unit)..
TimeXX_Add
Returns a string that represents the sum of two TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TimeXX_Subtract
Returns a string that represents the difference between two TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TimeXX_Sum
Returns a string that represents the sum TIMEXX time strings. The result is displayed as hh:mm:ss:xx.
TopAverage
Returns the average of the top n values in a list. AVERAGETOP
UniqueItems
UNIQUE added in 2021.
User
USERNAME
VInterpolate
VLOOKUPINTERPOLATE
WhichDay
Returns a date that corresponds to a specified day in a month. For example, the date of the first Friday in January for a given year. WHICHDAY
XDate
DATESBEFORE1900
XDate_Add
DATESBEFORE1900
XDate_Day
DATESBEFORE1900
XDate_Dif
DATESBEFORE1900
XDate_Dow
DATESBEFORE1900
XDATE_Month
DATESBEFORE1900
XDate_Year
DATESBEFORE1900
XDate_YearDif
DATESBEFORE1900

OzGrid Functions

Library FunctionDescription
AutoFilter_Criteria 
CalculationMode 
CalculationState 
CellColorFORMATGET*
ColorRankFORMATGET*
ConvertCurrencyToEnglish 
Count_Once 
CountWordsWORDSCOUNT
FindNth 
Five_Con_VLookup 
Four_Con_VLookup 
Get_WordWORDNO
GetAddressHYPERLINKGET*
GetCommentTextCOMMENTGET*
GetFilenameWORKBOOKFILENAME*
GetMaxBetweenReturns the largest value that is between a range. MAXBETWEEN
HowManyDaysInMonth 
IsFormulaISFORMULA added in Excel 2013 to the Information category.
Returns TRUE if the cell has a formula or FALSE if it doesn't.
LastDayOfMonthLASTDATE_INTHISMONTH
Lookup_Occurrence 
MyFullNameWORKBOOKPATHFILENAME*
MyNameReturns the application's user name or the domain username. USERNAME
NthDayOfMonth 
OzGridLookup 
RandLottoRANDOMNUMBER
ReturnLastWordWORDNO-LAST
ReverseCellReturns the contents of a particular cell with all the characters reversed. REVERSE
SheetNameWORKSHEETNAME*
SpellNumberSPELLNUMBER*
SumEveryNth 
Three_Con_VLookup 
Two_Con_VLookup 
VLookAllSheetsVLOOKUPALL
WorkbookExistsFILEEXISTS*
Library Function
Description
AutoFilter_Criteria
CalculationMode
CalculationState
CellColor
FORMATGET*
ColorRank
FORMATGET*
ConvertCurrencyToEnglish
Count_Once
CountWords
WORDSCOUNT
FindNth
Five_Con_VLookup
Four_Con_VLookup
Get_Word
WORDNO
GetAddress
HYPERLINKGET*
GetCommentText
COMMENTGET*
GetFilename
WORKBOOKFILENAME*
GetMaxBetween
Returns the largest value that is between a range. MAXBETWEEN
HowManyDaysInMonth
IsFormula
ISFORMULA added in Excel 2013 to the Information category.
Returns TRUE if the cell has a formula or FALSE if it doesn't.
LastDayOfMonth
LASTDATE_INTHISMONTH
Lookup_Occurrence
MyFullName
WORKBOOKPATHFILENAME*
MyName
Returns the application's user name or the domain username. USERNAME
NthDayOfMonth
OzGridLookup
RandLotto
RANDOMNUMBER
ReturnLastWord
WORDNO-LAST
ReverseCell
Returns the contents of a particular cell with all the characters reversed. REVERSE
SheetName
WORKSHEETNAME*
SpellNumber
SPELLNUMBER*
SumEveryNth
Three_Con_VLookup
Two_Con_VLookup
VLookAllSheets
VLOOKUPALL
WorkbookExists
FILEEXISTS*

MoreFunc Functions

Library FunctionDescription
ANSI128Strips the accents from a string
ARRAY.FILTERReturns only the visible cells of a range (in an array)
ARRAY.JOINJoins various items (ranges, unions, strings, numbers...) in a single array
CHBASEConverts a value from a base into another base
COUNTDIFFNumber of unique values in a range or array
COUNTIF.3DSame as COUNTIF working with 3D references
DATE.DIFFReturns an age in years, months and days
EASTERDATEDate of Easter Sunday for a given year
EVALEvaluates a formula or expression
FILENAMEName of the workbook
FORMULATEXTReturns the formula of a cell
GEOMEAN.EXTSame as GEOMEAN, higher capacity
GETVReturns a temporary variable value stored by SETV
HEX.ANDBitwise AND between hexadecimal numbers
HEX.FORMATFormats and checks the validity of an hexadecimal number
HEX.NEGInverts the sign of an hexadecimal number (2's complement)
HEX.NOTNegates (NOT) an hexadecimal number
HEX.ORBitwise OR between hexadecimal numbers
HEX.SUMAdds hexadecimal numbers
HSORTSorts a range or an array (supports up to 14 sort keys) - vertical
HSORT.IDXSort index of a range or array (supports up to 14 sort keys) - vertical
INDIRECT.EXTsame as INDIRECT working also with closed workbooks
INTVECTORReturns a vector of consecutive integers in the ascending order
ISO.WEEKNUMISO-compliant week number of a day. Excel 2013 added ISOWEEKNUM
LASTROWLast filled cell in a column. LASTINROW
MATRIXROUNDAdjusts an array of rounded numbers (=>sum of percentages = always 100%)
MCONCATConcatenates all values in a range or an array
MDETERM.EXTSame as MDETERM, faster and supporting larger arrays
MINVERSE.EXTSame as MINVERSE, faster and supporting larger arrays
MMAXReturns the N highest numbers of a range or an array
MMINReturns the N lowest numbers of a range or an array
MMULT.EXTSame as MMULT, faster and supporting larger arrays
MRANDSeries of random integers without repetitions
NBTEXTConverts a positive number into spelled-out text (supports 13 languages)
PAGENUMPage number of a cell
PN.ISPRIMEReturns TRUE if a number is a prime number (up to 255 digits)
PN.NEXTReturns the next prime number (up to 255 digits)
RECALLReturns the previous value of the calling cell before the last calculation
REGEX.COMPReturns TRUE if a text matches a regular expression
REGEX.COUNTCounts the matches of a regular expression in a string
REGEX.FINDLocation of a substring matching a regular expression
REGEX.LENCounts the matches of a regular expression in a string
REGEX.MIDReturns a substring matching a regular expression
REGEX.SUBSTITUTEReplaces a substring matching a regular expression with a new string
SETVStores a value in a temporary variable
SHEETNAMEName of a sheet in the workbook. WORKSHEETNAME
SHEETOFFSETReturns a range that is a specified number of sheets from a range
STDEV.GROUPEDStandard deviation based on a sample (data grouped in classes)
STDEVP.GROUPEDStandard deviation based on the entire population (grouped data)
TEXTREVERSEReverses the characters of a string. REVERSE
THREEDCoerces a 3D range into a single array - enables array formulae with 3D references
UNION.OFFSETOFFSET-like function working with unions (discontinguous ranges)
UNIQUEVALUESAdded in 2021 UNIQUE
VAR.GROUPEDVariance based on a sample (data grouped in classes)
VARP.GROUPEDVariance based on the entire population (grouped data)
VSORTSorts a range or an array (supports up to 14 sort keys) - horizontal
VSORT.IDXSort index of a range or array (supports up to 14 sort keys) - horizontal
WEIGHTED.AVERAGEReturns a weighted average
WMIDExtracts a word or a group of words from a text
WORDCOUNTNumber of words in a text
XLM.GET.CELLInformations about the formatting, location or contents of a cell or a range
XLM.GET.DOCUMENTInformations about the workbook (number of sheets, author, summary...)
XLM.GET.WORKBOOKInformations about the current sheet or the workbook (protection, type of sheet...)
XLM.GET.WORKSPACEInformations about the workspace (country version of Excel, startup path...)
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
FORMULATEXT
Returns the formula of a cell
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
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
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
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
XLM.GET.CELL
Informations about the formatting, location or contents of a cell or a range
XLM.GET.DOCUMENT
Informations about the workbook (number of sheets, author, summary...)
XLM.GET.WORKBOOK
Informations about the current sheet or the workbook (protection, type of sheet...)
XLM.GET.WORKSPACE
Informations about the workspace (country version of Excel, startup path...)

Excel Kid Functions

link - excelkid.com/excel-functions/

Library FunctionDescription
ABBREVIATE(Text)
ASG 
AVERAGE_FLN(Maths)
AVERAGEHIGH(Maths)
AVERAGELOW(Maths)
AVERAGEN(Maths)
AVERAGESHEET(Maths)
BETWEEN 
CAMEL_CASE(Text)
CAPITALIZE(Text)
CELLARRAY 
COMPANY_CASE(Text)
COMPARECompare 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)
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)
INRANGEChecks 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 
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)
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
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)


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