Complete List

Add days to a dateDate - Add or Subtract
Add days to a date avoiding weekendsDate - Add or Subtract
Add hours to a timeTime - Add or Subtract
Add minutes to a timeTime - Add or Subtract
Add months to a dateDate - Add or Subtract
Add workdays to a dateDate - Add or Subtract
Add years to a dateDate - Add or Subtract
Average cells after subtractionNumber - Average
Average cells that contain numbersNumber - Average
Average cells that contain numbers ignoring duplicatesNumber - Average
Average cells that contain numbers ignoring zerosNumber - Average
Average cells that contain numbers weighted averageNumber - Average
Average numbersNumber - Average
Average the n largest numbersNumber - Average
Average the n smallest numbersNumber - Average
Convert a date string to a date valueDate - Convert
Convert a number into currency formatNumber - Convert
Convert hours to a timeTime - Convert
Convert minutes to a timeTime - Convert
Convert numbers to textText - Convert
Convert seconds to a timeTime - Convert
Convert text to numbersText - Convert
Convert time to time zoneTime - Convert
Count cells between 2 datesCounting - Between
Count cells between 2 numbersCounting - Between
Count cells equal to 1 valueCounting - Equal To
Count cells equal to 1 value case sensitiveCounting - Equal To
Count cells equal to 2 valuesCounting - Equal To
Count cells equal to 3 or more valuesCounting - Equal To
Count cells equal to either x or yCounting - Equal To
Count cells equal to one of manyCounting - Equal To
Count cells greater than a valueCounting - Less Than or Greater Than
Count cells less than a valueCounting - Less Than or Greater Than
Count cells not equal to 1 valueCounting - Not Equal To
Count cells not equal to 1 value case sensitiveCounting - Not Equal To
Count cells not equal to 2 valuesCounting - Not Equal To
Count cells not equal to 3 or more valuesCounting - Not Equal To
Count cells not equal to either x or yCounting - Not Equal To
Count cells that are a number of characters longCounting - Contain
Count cells that are blankCounting - Equal To
Count cells that are errorsCounting - Contain
Count cells that are even numbersCounting - Contain
Count cells that are negative numbersCounting - Contain
Count cells that are not blankCounting - Not Equal To
Count cells that are not equal to either x or yCounting - Are
Count cells that are not equal to one of manyCounting - Are
Count cells that are not errorsCounting - Not Equal To
Count cells that are not textCounting - Not Equal To
Count cells that are numbersCounting - Are
Count cells that are odd numbersCounting - Are
Count cells that are positive numbersCounting - Are
Count cells that are textCounting - Are
Count cells that are unique numbersCounting - Are
Count cells that are unique text stringsCounting - Are
Count cells that are unique text strings with 1 conditionCounting - Are
Count cells that begin withCounting - Contain
Count cells that contain 1 text stringCounting - Contain
Count cells that contain 2 text stringsCounting - Contain
Count cells that contain either x or yCounting - Contain
Count cells that contain errorsCounting - Contain
Count cells that contain n charactersCounting - Contain
Count cells that contain numbersCounting - Contain
Count cells that contain numbers with 1 conditionCounting - Conditional
Count cells that contain numbers with multiple conditionsCounting - Conditional
Count cells that contain textCounting - Contain
Count cells that do not begin withCounting - Contain
Count cells that do not contain a text stringCounting - Contain
Count cells that do not contain any numbersCounting - Contain
Count cells that do not end withCounting - Contain
Count cells that end withCounting - Contain
Count cells that meet either conditionCounting - Conditional
Count cells with formattingCounting - Conditional
Count cells with shadingCounting - Conditional
Count columns with multiple OR criteriaCounting - Other
Count differences between 2 cell rangesCounting - Conditional
Count hidden rowsCounting - Other
Count hidden rows in a filtered columnCounting - Other
Count hidden rows with 1 conditionCounting - Other
Count hidden rows with multiple conditionsCounting - Other
Count if items are in a listCounting - Other
Count if row meets internal criteriaCounting - Other
Count if row meets multiple internal criteriaCounting - Other
Count if two criteria matchCounting - Other
Count matches between 2 columnsCounting - Other
Count rows with multiple OR criteriaCounting - Other
Count substring occurrencesCounting - Other
Count total characters in rangeCounting - Other
Count total matches in 2 rangesCounting - Other
Count unique numbersCounting - Other
Count unique numbers with 1 conditionCounting - Other
Count unique text stringsCounting - Other
Count unique text strings with 1 conditionCounting - Other
Count unique valuesCounting - Other
Count visible rowsCounting - Other
Count visible rows in a filtered columnCounting - Other
Count visible rows with 1 conditionCounting - Other
Count visible rows with multiple conditionsCounting - Other
Display a date in a particular formatDate - Display
Display a date in US date formatDate - Display
Display a persons age in yearsDate - Display
Display numbers to the nearest fractionNumber - Display
Display random charactersText - Display
Display random numbers between 1 and 25Number - Display
Display the 3rd Monday in a monthDate - Display
Display the current dateDate - Display
Display the current date and timeDate - Display
Display the current dayDate - Display
Display the current monthDate - Display
Display the current quarterDate - Display
Display the current timeTime - Display
Display the current yearDate - Display
Display the date from date and timeDate - Display
Display the date of the Monday in the current weekDate - Display
Display the day of the week occurrenceDate - Display
Display the number corresponding to a given monthDate - Display
Display the percentage changeNumber - Display
Display the time elapsed between 2 timesTime - Display
Display the time from date and timeTime - Display
Display the time rounded to the nearest 15 minutesTime - Display
Display the week number of the current dateDate - Display
Display two strings joined togetherText - Display
Display work hours between 2 datesTime - Display
Find a matching valueLookup - Find
Find a matching value case sensitiveLookup - Find
Find a matching value cross referenceLookup - Find
Find a matching value in any columnLookup - Find
Find a matching value in first columnLookup - Find
Find a partial matchLookup - Find
Find a particular occurrenceLookup - Find
Find the cell address of the largest numberOther - Other
Find the closest matchLookup - Find
Find the largest numberLookup - Find
Find the largest number with 1 conditionLookup - Find
Find the largest number with multiple conditionsLookup - Find
Find the n largest numbersLookup - Find
Find the n smallest numbersLookup - Find
Find the nth largest numberLookup - Find
Find the nth largest number with 1 conditionLookup - Find
Find the nth matchLookup - Find
Find the nth smallest numberLookup - Find
Find the nth smallest number with 1 conditionLookup - Find
Find the position of the active worksheet in the workbookOther - Other
Find the row of the largest numberOther - Other
Find the smallest numberLookup - Find
Find the smallest number with 1 conditionLookup - Find
Find the smallest number with multiple conditionsLookup - Find
Find the unique values in a rangeLookup - Find
First day of the current monthDate - First
First day of the previous monthDate - First
First Monday of the next monthDate - First
First Monday of the previous monthDate - First
First weekday of the yearDate - First
Last day of the current monthDate - Last
Last day of the previous monthDate - Last
Last Monday of the next monthDate - Last
Last Monday of the previous monthDate - Last
Last weekday of the yearDate - Last
Multiply numbers and sumSumming - Other
Number of days between 2 datesDate - Number of Days
Number of days in a particular monthDate - Number of Days
Number of days in a particular yearDate - Number of Days
Number of days left in the current monthDate - Number of Days
Number of days left in the current yearDate - Number of Days
Number of days that have passed in the current monthDate - Number of Days
Number of days that have passed in the current yearDate - Number of Days
Number of months between 2 datesDate - Number of Months
Number of weekdaysDate - Number of
Number of weekdays between 2 datesDate - Number of
Number of weekdays in a particular monthDate - Number of
Number of weekdays left in the current monthDate - Number of
Number of weekdays left in the current yearDate - Number of
Number of weekdays that have passed in the current monthDate - Number of
Number of weekdays that have passed in the current yearDate - Number of
Number of weekend daysDate - Number of
Number of weekend days between 2 datesDate - Number of
Number of weekend days in a particular monthDate - Number of
Number of weekend days in a particular yearDate - Number of
Number of years between 2 datesDate - Number of Years
Only allow a certain number of charactersData Validation - Only allow
Only allow characters in uppercaseData Validation - Only allow
Only allow dates in a particular rangeData Validation - Only allow
Only allow dates that are weekdaysData Validation - Only allow
Only allow dates that are weekendsData Validation - Only allow
Only allow entries in a particular formatData Validation - Only allow
Only allow numbersData Validation - Only allow
Only allow numbers in a particular rangeData Validation - Only allow
Only allow percentagesData Validation - Only allow
Only allow textData Validation - Only allow
Only allow timesData Validation - Only allow
Only allow unique values no duplicatesData Validation - Only allow
Only allow values whose sum is restrictedData Validation - Only allow
Only allow yes or noData Validation - Only allow
Remove last n charactersText - Remove
Remove one wordText - Remove
Remove unwanted charactersText - Remove
Replace one character with anotherText - Replace
Replace one word with anotherText - Replace
Replace text by matchingText - Replace
Replace text by positionText - Replace
Return a substringText - Return
Return all numbers reduced by 10 percentNumber - Return
Return an array of worksheet namesOther - Other
Return every fourth entry in a listText - Return
Return the decimal part of a numberNumber - Return
Return the digits in reverse orderNumber - Return
Return the first name from full nameText - Return
Return the first wordText - Return
Return the integer part of a numberNumber - Return
Return the last name from full nameText - Return
Return the last wordText - Return
Return the longest string in a columnText - Return
Return the middle name from full nameText - Return
Return the most frequently occurring wordText - Return
Return the nth wordText - Return
Return the number from a number and textText - Return
Return the text converted to sentence caseText - Return
Return the value from the cell aboveText - Return
Return the words in reverse orderText - Return
Return the workbook name from a full pathOther - Other
Round a number downNumber - Round
Round a number down to a nearest multipleNumber - Round
Round a number to n significant figuresNumber - Round
Round a number to nearest 100Number - Round
Round a number to nearest 5Number - Round
Round a number upNumber - Round
Round a number up to a nearest multipleNumber - Round
Shade cells between 2 datesFormatting - Shade all
Shade cells between 2 numbersFormatting - Shade all
Shade cells in a particular rowFormatting - Shade all
Shade cells in alternate rowsFormatting - Shade all
Shade cells that are blankFormatting - Shade all
Shade cells that are errorsFormatting - Shade all
Shade cells that are even numbersFormatting - Shade all
Shade cells that are negative numbersFormatting - Shade all
Shade cells that are not errorsFormatting - Shade all
Shade cells that are numbersFormatting - Shade all
Shade cells that are odd numbersFormatting - Shade all
Shade cells that are positive numbersFormatting - Shade all
Shade cells that contain a text stringFormatting - Shade all
Shade cells that contain numbersFormatting - Shade all
Shade cells that do not contain a text stringFormatting - Shade all
Shade cells with dates equal to a valueFormatting - Shade all
Shade cells with dates in the next n daysFormatting - Shade all
Shade cells with duplicate rowsFormatting - Shade all
Shade cells with duplicate valuesFormatting - Shade all
Shade cells with formattingFormatting - Shade all
Shade dates greater than a valueFormatting - Shade all
Shade dates less than a valueFormatting - Shade all
Shade dates that are weekdaysFormatting - Shade all
Shade dates that are weekendsFormatting - Shade all
Shade items in a listFormatting - Shade all
Shade positive changesFormatting - Shade all
Subtract days from a dateDate - Add or Subtract
Subtract months from a dateDate - Add or Subtract
Subtract years from a dateDate - Add or Subtract
Sum across worksheetsSumming - Other
Sum across worksheets with 1 conditionSumming - Other
Sum all the individual digits of a numberSumming - Other
Sum by groupSumming - Other
Sum by monthSumming - Other
Sum cells after multiplyingSumming - Other
Sum cells between 2 datesSumming - Between
Sum cells between 2 numbersSumming - Between
Sum cells equal to 2 valuesSumming - Equal To
Sum cells equal to 3 or more valuesSumming - Equal To
Sum cells equal to a valueSumming - Equal To
Sum cells equal to a value case sensitiveSumming - Equal To
Sum cells greater than a valueSumming - Less Than or Greater Than
Sum cells less than a valueSumming - Less Than or Greater Than
Sum cells not equal to blankSumming - Not Equal To
Sum cells not equal to errorsSumming - Not Equal To
Sum cells that begin withSumming - Contain
Sum cells that contain a text stringSumming - Contain
Sum cells that contain a unique text stringSumming - Other
Sum cells that contain even numbersSumming - Contain
Sum cells that contain n charactersSumming - Other
Sum cells that contain negative numbersSumming - Contain
Sum cells that contain numbersSumming - Other
Sum cells that contain numbers with 1 conditionSumming - Conditional
Sum cells that contain numbers with multiple conditionsSumming - Conditional
Sum cells that contain odd numbersSumming - Contain
Sum cells that contain positive numbersSumming - Contain
Sum cells that contain textSumming - Other
Sum cells that contain unique numbersSumming - Other
Sum cells that do not contain a text stringSumming - No Contain
Sum cells that do not contain errorsSumming - Other
Sum cells that end withSumming - Contain
Sum cells that meet 1 conditionSumming - Other
Sum cells that meet either conditionSumming - Other
Sum cells that meet multiple conditionsSumming - Other
Sum cells using array formulaSumming - Other
Sum cells with formattingSumming - Other
Sum cells with OR criteriaSumming - Other
Sum cells with shadingSumming - Other
Sum comma delimited numbersSumming - Other
Sum entire columnSumming - Other
Sum entire rowSumming - Other
Sum every n cells in a columnSumming - Other
Sum every n cells in a rangeSumming - Other
Sum every n cells in a rowSumming - Other
Sum numbersSumming - Other
Sum running totalSumming - Other
Sum the n largest numbersSumming - Other
Sum the n smallest numbersSumming - Other
Sum top n largest numbersSumming - Other
Sum top n smallest numbersSumming - Other
Test if a substring existsConditional - If
Test if cell contains 1 text stringConditional - If
Test if cell is between 2 numbersConditional - If
Test if cell is blankConditional - If
Test if cell is greater than 1 valueConditional - If
Test if cell is not blankConditional - If
Test if year is a leap yearDate - Test

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited