Alphabetical A - M

List of user defined functions

ACRONYMReturns the first letter of each word.
AGEReturns the age of a person given a birthday.
AVERAGEIFSVISIBLEReturns the average of the visible non blank cells that satisfies multiple condition.
AVERAGETOPReturns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLEReturns the average value from the visible, non blank cells.
BETWEENReturns whether a particular cell value is between a range of values.
CELLTYPEReturns the type of value that is contained in a particular cell.
COLUMNWIDTHReturns the column width of the active cell.
COMMENTGETReturns the comment associated with a particular cell.
COMPUTERNAMEReturns the full computer name of where the code is running.
CONTAINSReturns whether a string is contained inside another string.
COUNTFORMATReturns the number of cells that have been formatted with a particular colour.
COUNTIFSVISIBLEReturns the number of visible non blank cells that satisfies multiple conditions.
COUNTNUMBEROFDAYSReturns the number of days in a month and/or year.
COUNTNUMBEROFDAYSReturns the number of days in a week, month, year
COUNTSUBSTRINGReturns the number of times a substring occurs in a longer string.
COUNTTEXTCELLSReturns the number of cells that contain text.
COUNTVISIBLEReturns the number of visible non blank cells.
DATEUNITSReturns the number of units between two dates.
DATESBEFORE1900Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAYReturns the date given a month, a week number and a day of the week.
DAYSTOCHRISTMASReturns the number of days to Christmas.
EXTRACTFILENAMEReturns just the file name from a full file path.
EXTRACTFILEPATHReturns just the file path from a full file path.
EXTRACTNUMBERSReturns only the numbers from a text string.
EXTRACTTEXTReturns only the text from a text string.
FILEEXISTSReturns whether a particular file exists.
FINDMATCHReturns the position of an item in a list.
FIRSTDATEReturns the first date of the day of a week, month or year.
FOLDEREXISTSReturns whether a particular folder exists.
FORMATGETReturns the font colour index used to format a particular cell.
FORMATGET_FONTNAMEReturns the font name used to format a particular cell.
FORMATGET_FONTSIZEReturns the font size used to format a particular cell.
HYPERLINKGETReturns the hyperlink associated with a particular cell.
INVERSEReturns the number divided into 1.
ISBOLDReturns whether a particular cell has bold formatting applied.
ISDATEReturns whether a date is the first (or last) of a week, month or year.
ISFORMULAReturns whether a particular cell contains a formula.
ISINTEGERReturns whether a particular number is an integer number.
ISITALICReturns whether a particular cell has italic formatting applied.
ISLIKEReturns whether a particular string matches a certain pattern.
ISLOCKEDReturns whether a particular cell is locked or not.
ISLOWERReturns whether a particular string is in lower case.
ISMERGEDReturns whether a particular cell is merged or not.
ISPRIMEReturns whether a particular number is a prime number.
ISPROPERReturns whether a particular string is in proper case.
ISUNDERLINEReturns whether a particular cell has underline formatting applied to it.
ISUPPERReturns whether a particular string is in upper case.
ISWRAPPEDReturns whether a particular cell has text wrap formatting applied.
LASTDATEReturns the date of the last day of a week, month or year.
LASTWORDReturns the last word from a text string.
LASTINCOLUMNReturns the last cell that contains data in a particular column.
LASTINROWReturns the last cell that contains data in a particular row.
MAXIFSVISIBLEReturns the largest of the visible non blank cells that satisfies multiple condition.
MAXVISIBLEReturns the largest value from the visible, non blank cells.
MEDIANIFSReturns the middle value in a range of values that satisfies multiple conditions.
MEDIANIFSVISIBLEReturns the middle value from visible non blank cells that satisfies multiple conditions.
MEDIANVISIBLEReturns the middle value from the visible cells.
MINIFSVISIBLEReturns the smallest of the visible non blank cells that satisfies multiple condition.
MINVISIBLEReturns the smallest value from the visible, non blank cells.
ACRONYM
Returns the first letter of each word.
AGE
Returns the age of a person given a birthday.
AVERAGEIFSVISIBLE
Returns the average of the visible non blank cells that satisfies multiple condition.
AVERAGETOP
Returns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLE
Returns the average value from the visible, non blank cells.
BETWEEN
Returns whether a particular cell value is between a range of values.
CELLTYPE
Returns the type of value that is contained in a particular cell.
COLUMNWIDTH
Returns the column width of the active cell.
COMMENTGET
Returns the comment associated with a particular cell.
COMPUTERNAME
Returns the full computer name of where the code is running.
CONTAINS
Returns whether a string is contained inside another string.
COUNTFORMAT
Returns the number of cells that have been formatted with a particular colour.
COUNTIFSVISIBLE
Returns the number of visible non blank cells that satisfies multiple conditions.
COUNTNUMBEROFDAYS
Returns the number of days in a month and/or year.
COUNTNUMBEROFDAYS
Returns the number of days in a week, month, year
COUNTSUBSTRING
Returns the number of times a substring occurs in a longer string.
COUNTTEXTCELLS
Returns the number of cells that contain text.
COUNTVISIBLE
Returns the number of visible non blank cells.
DATEUNITS
Returns the number of units between two dates.
DATESBEFORE1900
Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY
Returns the date given a month, a week number and a day of the week.
DAYSTOCHRISTMAS
Returns the number of days to Christmas.
EXTRACTFILENAME
Returns just the file name from a full file path.
EXTRACTFILEPATH
Returns just the file path from a full file path.
EXTRACTNUMBERS
Returns only the numbers from a text string.
EXTRACTTEXT
Returns only the text from a text string.
FILEEXISTS
Returns whether a particular file exists.
FINDMATCH
Returns the position of an item in a list.
FIRSTDATE
Returns the first date of the day of a week, month or year.
FOLDEREXISTS
Returns whether a particular folder exists.
FORMATGET
Returns the font colour index used to format a particular cell.
FORMATGET_FONTNAME
Returns the font name used to format a particular cell.
FORMATGET_FONTSIZE
Returns the font size used to format a particular cell.
HYPERLINKGET
Returns the hyperlink associated with a particular cell.
INVERSE
Returns the number divided into 1.
ISBOLD
Returns whether a particular cell has bold formatting applied.
ISDATE
Returns whether a date is the first (or last) of a week, month or year.
ISFORMULA
Returns whether a particular cell contains a formula.
ISINTEGER
Returns whether a particular number is an integer number.
ISITALIC
Returns whether a particular cell has italic formatting applied.
ISLIKE
Returns whether a particular string matches a certain pattern.
ISLOCKED
Returns whether a particular cell is locked or not.
ISLOWER
Returns whether a particular string is in lower case.
ISMERGED
Returns whether a particular cell is merged or not.
ISPRIME
Returns whether a particular number is a prime number.
ISPROPER
Returns whether a particular string is in proper case.
ISUNDERLINE
Returns whether a particular cell has underline formatting applied to it.
ISUPPER
Returns whether a particular string is in upper case.
ISWRAPPED
Returns whether a particular cell has text wrap formatting applied.
LASTDATE
Returns the date of the last day of a week, month or year.
LASTWORD
Returns the last word from a text string.
LASTINCOLUMN
Returns the last cell that contains data in a particular column.
LASTINROW
Returns the last cell that contains data in a particular row.
MAXIFSVISIBLE
Returns the largest of the visible non blank cells that satisfies multiple condition.
MAXVISIBLE
Returns the largest value from the visible, non blank cells.
MEDIANIFS
Returns the middle value in a range of values that satisfies multiple conditions.
MEDIANIFSVISIBLE
Returns the middle value from visible non blank cells that satisfies multiple conditions.
MEDIANVISIBLE
Returns the middle value from the visible cells.
MINIFSVISIBLE
Returns the smallest of the visible non blank cells that satisfies multiple condition.
MINVISIBLE
Returns the smallest value from the visible, non blank cells.

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