Migration


ASAP Utilities Functions

asap-utilities.com

CELLCOLORINDEXFORMATGET
COUNTBYCELLCOLORCOUNTFORMAT
COUNTBYFONTCOLORCOUNTFORMAT
COUNTCHARCOUNTSUBSTRING
COUNTSHADESCOUNTFORMAT
EXTRACTFILENAMEEXTRACTFILENAME
EXTRACTFOLDERNAMEEXTRACTFOLDERPATH
EXTRACTNUMBERSEXTRACTNUMBERS
FILENAMEWORKBOOKFILENAME
FILEPATHWORKBOOKPATH
FILEPROPERTIESFILEPROPERTIES
FONTCOLORINDEXFORMATGET
FULLFILENAMEWORKBOOKPATHFILENAME
GETCOMMENTCOMMENTGET
GETDOMAINHYPERLINKGET_DOMAIN
GETFONTNAMEFORMATGET
GETFONTSIZEFORMATGET
GETFORMULAFORMULAGET
GETFORMULAINTFORMULAGET_INTER
GETHYPERLINKHYPERLINKGET
GETNUMBERFORMATNUMBERFORMATGET
ISBOLDISBOLD
ISFORMULAISFORMULA
LOADIMAGEIMAGEDISPLAY
MERGECELLSMERGECELLS
RANDOMPASSWORDRANDOMPASSWORD
SHEETNAMEWORKSHEETNAME
SPELLNUMBERSPELLNUMBER
STRIPNUMBERSREMOVENUMBERS
SUMBYCELLCOLORSUMFORMAT
SUMBYFONTCOLORSUMFORMAT

Power Utility Pack Functions

spreadsheetpage.com

CELLCOLORFORMATGET
CELLHASFORMULAISFORMULA
CELLTYPECELLTYPE
CHAR2Excel 2013 added UNICODE
CODE2Excel 2013 added UNICHAR
CONTAINSCONTAINS
COUNTAVISIBLECOUNTAVISIBLE
COUNTBETWEENCOUNTBETWEEN
CreditCard 
DAYSINMONTHCOUNTNUMBEROFDAYS
DOLLARTEXTSPELLNUMBER
EXCELDIREXCELDIR
EXTRACTELEMENTWORDGET
FILEEXISTSFILEEXISTS
FILENAMEWORKBOOKFILENAME
FONTCOLORFORMATGET
HINTERPOLATEHLOOKUPINTERPOLATE
INSERTSTRINGINSERTSTRING
ISLIKEISLIKE
LASTINCOLUMNLASTINCOLUMN
LASTINROWLASTINROW
MAXALLSHEETSALLSHEETS_MAX
MINALLSHEETSALLSHEETS_MIN
MONTHWEEKWEEKNUMBER
NUMBERFORMATNUMBERFORMATGET
ParseName 
REMOVESPACESREMOVESPACES
SayIt 
SCRAMBLESCRAMBLE
SELECTONESELECTONE
SHEETCOUNTWORKSHEETSCOUNT
SHEETNAMEWORKSHEETNAME
SHEETOFFSETSHEETOFFSET
STATICRANDRANDOMNUMBER_STATIC
SUMALLSHEETSALLSHEETS_SUM
SUMVISIBLESUMVISIBLE
TimeXXna
TimeXX_Addna
TimeXX_Subtractna
TimeXX_Sumna
TOPAVERAGEAVERAGETOP
UNIQUEITEMSUNIQUEITEMS
USERUSERNAME
VINTERPOLATEVLOOKUPINTERPOLATE
WhichDayWHICHDAY
XDATEDATESBEFORE1900
XDATE_ADDDATESBEFORE1900
XDATE_DAYDATESBEFORE1900
XDATE_DIFDATESBEFORE1900
XDATE_DOWDATESBEFORE1900
XDATE_MONTHDATESBEFORE1900
XDATE_YEARDATESBEFORE1900
XDATE_YEARDIFDATESBEFORE1900

OzGrid Functions

AutoFilter_Criteria 
CalculationMode 
CalculationState 
CellColorFORMATGET
ColorRankFORMATGET
ConvertCurrencyToEnglish 
Count_Once 
CountWordsWORDSCOUNT
FindNth 
Five_Con_VLookup 
Four_Con_VLookup 
Get_WordWORDNO
GetAddressHYPERLINKGET
GetCommentTextCOMMENTGET
GetFilenameWORKBOOKFILENAME
GetMaxBetweenMAXBETWEEN
HowManyDaysInMonth 
IsFormulaISFORMULA
LastDayOfMonthLASTDATE_INTHISMONTH
Lookup_Occurrence 
MyFullNameWORKBOOKPATHFILENAME
MyNameWORKBOOKFILENAME
NthDayOfMonth 
OzGridLookup 
RandLottoRANDOMNUMBER
ReturnLastWordWORDNO-LAST
ReverseCellREVERSE
SheetNameWORKSHEETNAME
SpellNumberNUMBERSTOWORD
SumEveryNth 
Three_Con_VLookup 
Two_Con_VLookup 
VLookAllSheetsVLOOKUPALL
WorkbookExistsFILEEXISTS

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