Alphabetical A - M

List of user defined functions

ACRONYMReturns the first letter of each word.
AGEReturns the age of a person given a birthday.
AVERAGEIFReturns the average value of cells that satisfies one condition.
AVERAGEIFSVISIBLEReturns the average of the visible non blank cells that satisfies multiple condition.
AVERAGEIFVISIBLEReturns the average of the visible non blank cells that satisfies one condition.
AVERAGETOPReturns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLE 
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.
COUNTIFVISIBLEReturns the number of visible non blank cells that satisfies one condition.
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.
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.
FORMULAGETReturns the formula from a particular cell.
HYPERLINKGETReturns the hyperlink associated with a particular cell.
IFERRORReturns a value or something else when it returns an error.
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.
MAXIFReturns the largest value in a range of values that match a certain condition.
MAXIFSVISIBLEReturns the largest of the visible non blank cells that satisfies multiple condition.
MAXIFVISIBLEReturns the largest of the visible non blank cells that satisfies one condition.
MEDIANIFReturns the middle value in a range of values that satisfies one condition.
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.
MEDIANIFVISIBLEReturns the middle value from the visible non blank cells that satisfies one condition.
MINIFReturns the smallest value in a range of values that satisfies one condition.
MINIFSVISIBLEReturns the smallest of the visible non blank cells that satisfies multiple condition.
MINIFVISIBLEReturns the smallest of the visible non blank cells that satisfies one condition.
ACRONYM
Returns the first letter of each word.
AGE
Returns the age of a person given a birthday.
AVERAGEIF
Returns the average value of cells that satisfies one condition.
AVERAGEIFSVISIBLE
Returns the average of the visible non blank cells that satisfies multiple condition.
AVERAGEIFVISIBLE
Returns the average of the visible non blank cells that satisfies one condition.
AVERAGETOP
Returns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLE
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.
COUNTIFVISIBLE
Returns the number of visible non blank cells that satisfies one condition.
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.
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.
FORMULAGET
Returns the formula from a particular cell.
HYPERLINKGET
Returns the hyperlink associated with a particular cell.
IFERROR
Returns a value or something else when it returns an error.
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.
MAXIF
Returns the largest value in a range of values that match a certain condition.
MAXIFSVISIBLE
Returns the largest of the visible non blank cells that satisfies multiple condition.
MAXIFVISIBLE
Returns the largest of the visible non blank cells that satisfies one condition.
MEDIANIF
Returns the middle value in a range of values that satisfies one condition.
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.
MEDIANIFVISIBLE
Returns the middle value from the visible non blank cells that satisfies one condition.
MINIF
Returns the smallest value in a range of values that satisfies one condition.
MINIFSVISIBLE
Returns the smallest of the visible non blank cells that satisfies multiple condition.
MINIFVISIBLE
Returns the smallest of the visible non blank cells that satisfies one condition.

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