Complete List

Abbreviate name and wordsPlaceholder
Add business days to a dateDate - Add or Subtract
Add business days to a date changing the days of the weekendDate - Add or Subtract
Add business days to a date excluding public holidaysDate - Add or Subtract
Add days to a date excluding weekendsPlaceholder
Add days to a date excluding weekends and changing the days of the weekendPlaceholder
Add days to a date excluding weekends and public holidaysPlaceholder
Add days to a date including weekendsDate - Add or Subtract
Add days to a date not landing on a weekendDate - 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 seconds to a timeTime - Add or Subtract
Add weeks to a dateDate - Add or Subtract
Add working days to a datePlaceholder
Add working days to a date changing the days of the weekendPlaceholder
Add working days to a date excluding public holidaysPlaceholder
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 using weighted averageNumber - Average
Average numbersNumber - Average
Average the n largest numbersNumber - Average
Average the n last 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 a number into wordsNumber - Convert
Convert a word into numbersText - Convert
Convert column letter to column numberOther - Other
Convert column number to column letterOther - Other
Convert hours to a timeTime - Convert
Convert minutes to a timeTime - Convert
Convert numbers to textText - Convert
Convert seconds to a timeTime - 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 1 valueCounting - Less Than or Greater Than
Count cells less than 1 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 dates between 2 datesCounting - Contain
Count cells that contain either x or yCounting - Contain
Count cells that contain errorsCounting - Contain
Count cells that contain even numbersCounting - Contain
Count cells that contain n charactersCounting - Contain
Count cells that contain negative numbersCounting - Contain
Count cells that contain numbersCounting - Contain
Count cells that contain numbers between 2 numbersCounting - Contain
Count cells that contain numbers greater than a valueCounting - Contain
Count cells that contain numbers less than a valueCounting - Contain
Count cells that contain numbers with 1 conditionCounting - Conditional
Count cells that contain numbers with multiple conditionsCounting - Conditional
Count cells that contain odd numbersCounting - Contain
Count cells that contain positive numbersCounting - Contain
Count cells that contain textCounting - Contain
Count cells that contain text of a certain lengthCounting - Contain
Count cells that contain unique datesCounting - Contain
Count cells that contain unique numbersCounting - Contain
Count cells that contain unique numbers with 1 conditionCounting - Conditional
Count cells that contain unique text stringsCounting - Contain
Count cells that contain unique text strings with 1 conditionCounting - Conditional
Count cells that contain unique valuesCounting - 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 errorsCounting - Contain
Count cells that do not contain any numbersCounting - Contain
Count cells that do not contain any numbers or textCounting - 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
Filter cells based on datesFiltering - Filtering
Filter cells based on either conditionFiltering - Filtering
Filter cells based on multiple conditionsFiltering - Filtering
Filter cells based on textFiltering - Filtering
Filter cells using array formulasFiltering - Filtering
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 excluding zeroLookup - Find
Find the largest number with 1 conditionLookup - Find
Find the largest number with multiple conditionsLookup - Find
Find the last entry in a columnLookup - 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 excluding zeroLookup - 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
Multiply numbers and sumSumming - Other
Number of business daysDate - Number of Days
Number of business days between 2 datesDate - Number of Days
Number of business days in a particular monthDate - Number of Days
Number of business days in a particular yearDate - Number of Days
Number of business days left in the current monthDate - Number of Days
Number of business days left in the current yearDate - Number of Days
Number of business days that have passed in the current monthDate - Number of Days
Number of business days that have passed in the current yearDate - Number of Days
Number of days between 2 datesDate - Number of Days
Number of days between 2 dates excluding weekendsDate - Number of Days
Number of days between 2 dates ignoring months and yearsDate - Number of Days
Number of days between 2 dates ignoring yearsDate - 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 months years from a dateDate - 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 mondays between 2 datesDate - Number of Days
Number of months and days between 2 datesDate - Number of Months
Number of months between 2 datesDate - Number of Months
Number of months between 2 dates ignoring days and yearsDate - Number of Months
Number of months weeks days between 2 datesDate - Number of Months
Number of occurrences of a particular day of the weekDate - Number of
Number of weekend daysDate - Number of Days
Number of weekend days between 2 datesDate - Number of Days
Number of weekend days in a particular monthDate - Number of Days
Number of weekend days in a particular yearDate - Number of Days
Number of weeks and days between 2 datesDate - Number of Weeks
Number of weeks between 2 datesDate - Number of Weeks
Number of working daysPlaceholder
Number of working days between 2 datesPlaceholder
Number of working days in a particular monthPlaceholder
Number of working days in a particular yearPlaceholder
Number of working days left in the current monthPlaceholder
Number of working days left in the current yearPlaceholder
Number of working days that have passed in the current monthPlaceholder
Number of working days that have passed in the current yearPlaceholder
Number of working hours between 2 datesTime - Number of Hours
Number of working hours between 2 timesTime - Number of Hours
Number of years and days between 2 datesDate - Number of Years
Number of years between 2 datesDate - Number of Years
Number of years months days between 2 datesDate - Number of Years
Number of years months days from a dateDate - 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 date in a particular formatDate - Display
Return a date in US date formatDate - Display
Return a list of non blank itemsOther - Other
Return a list of unique valuesOther - Other
Return a list of unique values ignoring blanksOther - Other
Return a number reduced by 10 percentNumber - Return
Return a persons age in yearsDate - Display
Return a persons age in years months daysDate - Display
Return a substringText - Return
Return an array of worksheet namesOther - Other
Return every fourth entry in a listText - Return
Return numbers to the nearest fractionNumber - Display
Return random charactersText - Display
Return random numbers between 1 and 25Number - Display
Return the 3rd monday in a monthDate - Display
Return the acronym from a text stringText - Return
Return the business daysDate - Display
Return the current dateDate - Display
Return the current date and timeDate - Display
Return the current dayDate - Display
Return the current monthDate - Display
Return the current quarterDate - Display
Return the current timeTime - Display
Return the current yearDate - Display
Return the date from a date and timeDate - Display
Return the date of the monday in the current weekDate - Display
Return the date of the monday in the next weekDate - Display
Return the date of the monday in the previous weekDate - Display
Return the day from dateDate - Return
Return the day nameDate - Display
Return the decimal part of a numberNumber - Return
Return the digits in reverse orderNumber - Return
Return the first business day of the yearDate - First
Return the first day of the current monthDate - First
Return the first day of the next monthDate - First
Return the first day of the previous monthDate - First
Return the first letter of each wordText - Return
Return the first monday of the current monthDate - First
Return the first monday of the next monthDate - First
Return the first monday of the previous monthDate - First
Return the first name from a full nameText - Return
Return the first weekday of the monthDate - First
Return the first weekday of the yearDate - First
Return the first wordText - Return
Return the integer part of a numberNumber - Return
Return the last business day of the yearDate - Last
Return the last day of the current monthDate - Last
Return the last day of the current quarterDate - Last
Return the last day of the next monthDate - Last
Return the last day of the previous monthDate - Last
Return the last monday of the current monthDate - Last
Return the last monday of the next monthDate - Last
Return the last monday of the previous monthDate - Last
Return the last name from a full nameText - Return
Return the last weekday of the monthDate - Last
Return the last weekday of the yearDate - Last
Return the last wordText - Return
Return the longest string in a columnText - Return
Return the middle name from a full nameText - Return
Return the month from a dateDate - Return
Return the most frequently occurring wordText - Return
Return the next business dayDate - Return
Return the next fridayDate - Return
Return the next mondayDate - Return
Return the next working dayDate - Return
Return the non blank items in a listOther - Other
Return the nth business day of the yearDate - Return
Return the nth day of the yearDate - Return
Return the nth wordText - Return
Return the number corresponding to a given monthDate - Display
Return the number equivalent for a number written as textText - Return
Return the number from a number and textText - Return
Return the percentage changeNumber - Display
Return the previous fridayDate - Return
Return the previous mondayDate - Return
Return the second wordText - Return
Return the shortest string in a columnText - Return
Return the text converted to sentence caseText - Return
Return the time elapsed between 2 timesTime - Display
Return the time from a date and timeTime - Display
Return the time rounded to the nearest 15 minutesTime - Display
Return the value from the cell aboveText - Return
Return the week number of the current dateDate - Return
Return the word equivalent for a numerical numberText - Return
Return the words in reverse orderText - Return
Return the workbook name from a full pathOther - Other
Return the working hours between 2 datesTime - Display
Return the working hours between 2 timesTime - Display
Return the year from a dateDate - Return
Return two strings joined togetherText - Display
Round a number downNumber - Round
Round a number down to the nearest 100Number - Round
Round a number down to the nearest 5Number - Round
Round a number down to the nearest multipleNumber - Round
Round a number to n significant figuresNumber - Round
Round a number upNumber - Round
Round a number up to the nearest 100Number - Round
Round a number up to the nearest 5Number - Round
Round a number up to the 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 business daysFormatting - Shade all
Shade dates that are weekdaysFormatting - Shade all
Shade dates that are weekendsFormatting - Shade all
Shade items in a list that appear in a sub listFormatting - Shade all
Shade positive changesFormatting - Shade all
Sort into a random orderOther - Other
Sort using a custom listOther - Other
Sort using one columnOther - Other
Sort using two columnsOther - Other
Subtract business days from a dateDate - Add or Subtract
Subtract business days from a date changing the days of the weekendDate - Add or Subtract
Subtract business days from a date excluding public holidaysDate - Add or Subtract
Subtract days from a dateDate - Add or Subtract
Subtract hours from a timeDate - Add or Subtract
Subtract minutes from a timeDate - Add or Subtract
Subtract months from a dateDate - Add or Subtract
Subtract seconds from a timeDate - Add or Subtract
Subtract weeks 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 last n numbersSumming - Other
Sum the n largest numbersSumming - Other
Sum the n smallest numbersSumming - Other
Test if a cell contains 1 text stringConditional - If
Test if a cell contains 2 text stringsConditional - If
Test if a cell is between 2 datesDate - Test
Test if a cell is between 2 numbersNumber - Test
Test if a cell is blankConditional - If
Test if a cell is greater than 1 valueConditional - If
Test if a cell is less than 1 valueConditional - If
Test if a cell is not blankConditional - If
Test if a year is a leap yearDate - Test
Abbreviate name and words
Placeholder
Add business days to a date
Date - Add or Subtract
Add business days to a date changing the days of the weekend
Date - Add or Subtract
Add business days to a date excluding public holidays
Date - Add or Subtract
Add days to a date excluding weekends
Placeholder
Add days to a date excluding weekends and changing the days of the weekend
Placeholder
Add days to a date excluding weekends and public holidays
Placeholder
Add days to a date including weekends
Date - Add or Subtract
Add days to a date not landing on a weekend
Date - Add or Subtract
Add hours to a time
Time - Add or Subtract
Add minutes to a time
Time - Add or Subtract
Add months to a date
Date - Add or Subtract
Add seconds to a time
Time - Add or Subtract
Add weeks to a date
Date - Add or Subtract
Add working days to a date
Placeholder
Add working days to a date changing the days of the weekend
Placeholder
Add working days to a date excluding public holidays
Placeholder
Add years to a date
Date - Add or Subtract
Average cells after subtraction
Number - Average
Average cells that contain numbers
Number - Average
Average cells that contain numbers ignoring duplicates
Number - Average
Average cells that contain numbers ignoring zeros
Number - Average
Average cells that contain numbers using weighted average
Number - Average
Average numbers
Number - Average
Average the n largest numbers
Number - Average
Average the n last numbers
Number - Average
Average the n smallest numbers
Number - Average
Convert a date string to a date value
Date - Convert
Convert a number into currency format
Number - Convert
Convert a number into words
Number - Convert
Convert a word into numbers
Text - Convert
Convert column letter to column number
Other - Other
Convert column number to column letter
Other - Other
Convert hours to a time
Time - Convert
Convert minutes to a time
Time - Convert
Convert numbers to text
Text - Convert
Convert seconds to a time
Time - Convert
Convert time to time zone
Time - Convert
Count cells between 2 dates
Counting - Between
Count cells between 2 numbers
Counting - Between
Count cells equal to 1 value
Counting - Equal To
Count cells equal to 1 value case sensitive
Counting - Equal To
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to either x or y
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells greater than 1 value
Counting - Less Than or Greater Than
Count cells less than 1 value
Counting - Less Than or Greater Than
Count cells not equal to 1 value
Counting - Not Equal To
Count cells not equal to 1 value case sensitive
Counting - Not Equal To
Count cells not equal to 2 values
Counting - Not Equal To
Count cells not equal to 3 or more values
Counting - Not Equal To
Count cells not equal to either x or y
Counting - Not Equal To
Count cells that are a number of characters long
Counting - Contain
Count cells that are blank
Counting - Equal To
Count cells that are errors
Counting - Contain
Count cells that are even numbers
Counting - Contain
Count cells that are negative numbers
Counting - Contain
Count cells that are not blank
Counting - Not Equal To
Count cells that are not equal to either x or y
Counting - Are
Count cells that are not equal to one of many
Counting - Are
Count cells that are not errors
Counting - Not Equal To
Count cells that are not text
Counting - Not Equal To
Count cells that are numbers
Counting - Are
Count cells that are odd numbers
Counting - Are
Count cells that are positive numbers
Counting - Are
Count cells that are text
Counting - Are
Count cells that are unique numbers
Counting - Are
Count cells that are unique text strings
Counting - Are
Count cells that are unique text strings with 1 condition
Counting - Are
Count cells that begin with
Counting - Contain
Count cells that contain 1 text string
Counting - Contain
Count cells that contain 2 text strings
Counting - Contain
Count cells that contain dates between 2 dates
Counting - Contain
Count cells that contain either x or y
Counting - Contain
Count cells that contain errors
Counting - Contain
Count cells that contain even numbers
Counting - Contain
Count cells that contain n characters
Counting - Contain
Count cells that contain negative numbers
Counting - Contain
Count cells that contain numbers
Counting - Contain
Count cells that contain numbers between 2 numbers
Counting - Contain
Count cells that contain numbers greater than a value
Counting - Contain
Count cells that contain numbers less than a value
Counting - Contain
Count cells that contain numbers with 1 condition
Counting - Conditional
Count cells that contain numbers with multiple conditions
Counting - Conditional
Count cells that contain odd numbers
Counting - Contain
Count cells that contain positive numbers
Counting - Contain
Count cells that contain text
Counting - Contain
Count cells that contain text of a certain length
Counting - Contain
Count cells that contain unique dates
Counting - Contain
Count cells that contain unique numbers
Counting - Contain
Count cells that contain unique numbers with 1 condition
Counting - Conditional
Count cells that contain unique text strings
Counting - Contain
Count cells that contain unique text strings with 1 condition
Counting - Conditional
Count cells that contain unique values
Counting - Contain
Count cells that do not begin with
Counting - Contain
Count cells that do not contain a text string
Counting - Contain
Count cells that do not contain any errors
Counting - Contain
Count cells that do not contain any numbers
Counting - Contain
Count cells that do not contain any numbers or text
Counting - Contain
Count cells that do not end with
Counting - Contain
Count cells that end with
Counting - Contain
Count cells that meet either condition
Counting - Conditional
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count columns with multiple OR criteria
Counting - Other
Count differences between 2 cell ranges
Counting - Conditional
Count hidden rows
Counting - Other
Count hidden rows in a filtered column
Counting - Other
Count hidden rows with 1 condition
Counting - Other
Count hidden rows with multiple conditions
Counting - Other
Count if items are in a list
Counting - Other
Count if row meets internal criteria
Counting - Other
Count if row meets multiple internal criteria
Counting - Other
Count if two criteria match
Counting - Other
Count matches between 2 columns
Counting - Other
Count rows with multiple OR criteria
Counting - Other
Count substring occurrences
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
Counting - Other
Count unique numbers
Counting - Other
Count unique numbers with 1 condition
Counting - Other
Count unique text strings
Counting - Other
Count unique text strings with 1 condition
Counting - Other
Count unique values
Counting - Other
Count visible rows
Counting - Other
Count visible rows in a filtered column
Counting - Other
Count visible rows with 1 condition
Counting - Other
Count visible rows with multiple conditions
Counting - Other
Filter cells based on dates
Filtering - Filtering
Filter cells based on either condition
Filtering - Filtering
Filter cells based on multiple conditions
Filtering - Filtering
Filter cells based on text
Filtering - Filtering
Filter cells using array formulas
Filtering - Filtering
Find a matching value
Lookup - Find
Find a matching value case sensitive
Lookup - Find
Find a matching value cross reference
Lookup - Find
Find a matching value in any column
Lookup - Find
Find a matching value in first column
Lookup - Find
Find a partial match
Lookup - Find
Find a particular occurrence
Lookup - Find
Find the cell address of the largest number
Other - Other
Find the closest match
Lookup - Find
Find the largest number
Lookup - Find
Find the largest number excluding zero
Lookup - Find
Find the largest number with 1 condition
Lookup - Find
Find the largest number with multiple conditions
Lookup - Find
Find the last entry in a column
Lookup - Find
Find the n largest numbers
Lookup - Find
Find the n smallest numbers
Lookup - Find
Find the nth largest number
Lookup - Find
Find the nth largest number with 1 condition
Lookup - Find
Find the nth match
Lookup - Find
Find the nth smallest number
Lookup - Find
Find the nth smallest number with 1 condition
Lookup - Find
Find the position of the active worksheet in the workbook
Other - Other
Find the row of the largest number
Other - Other
Find the smallest number
Lookup - Find
Find the smallest number excluding zero
Lookup - Find
Find the smallest number with 1 condition
Lookup - Find
Find the smallest number with multiple conditions
Lookup - Find
Find the unique values in a range
Lookup - Find
Multiply numbers and sum
Summing - Other
Number of business days
Date - Number of Days
Number of business days between 2 dates
Date - Number of Days
Number of business days in a particular month
Date - Number of Days
Number of business days in a particular year
Date - Number of Days
Number of business days left in the current month
Date - Number of Days
Number of business days left in the current year
Date - Number of Days
Number of business days that have passed in the current month
Date - Number of Days
Number of business days that have passed in the current year
Date - Number of Days
Number of days between 2 dates
Date - Number of Days
Number of days between 2 dates excluding weekends
Date - Number of Days
Number of days between 2 dates ignoring months and years
Date - Number of Days
Number of days between 2 dates ignoring years
Date - Number of Days
Number of days in a particular month
Date - Number of Days
Number of days in a particular year
Date - Number of Days
Number of days left in the current month
Date - Number of Days
Number of days left in the current year
Date - Number of Days
Number of days months years from a date
Date - Number of Days
Number of days that have passed in the current month
Date - Number of Days
Number of days that have passed in the current year
Date - Number of Days
Number of mondays between 2 dates
Date - Number of Days
Number of months and days between 2 dates
Date - Number of Months
Number of months between 2 dates
Date - Number of Months
Number of months between 2 dates ignoring days and years
Date - Number of Months
Number of months weeks days between 2 dates
Date - Number of Months
Number of occurrences of a particular day of the week
Date - Number of
Number of weekend days
Date - Number of Days
Number of weekend days between 2 dates
Date - Number of Days
Number of weekend days in a particular month
Date - Number of Days
Number of weekend days in a particular year
Date - Number of Days
Number of weeks and days between 2 dates
Date - Number of Weeks
Number of weeks between 2 dates
Date - Number of Weeks
Number of working days
Placeholder
Number of working days between 2 dates
Placeholder
Number of working days in a particular month
Placeholder
Number of working days in a particular year
Placeholder
Number of working days left in the current month
Placeholder
Number of working days left in the current year
Placeholder
Number of working days that have passed in the current month
Placeholder
Number of working days that have passed in the current year
Placeholder
Number of working hours between 2 dates
Time - Number of Hours
Number of working hours between 2 times
Time - Number of Hours
Number of years and days between 2 dates
Date - Number of Years
Number of years between 2 dates
Date - Number of Years
Number of years months days between 2 dates
Date - Number of Years
Number of years months days from a date
Date - Number of Years
Only allow a certain number of characters
Data Validation - Only allow
Only allow characters in uppercase
Data Validation - Only allow
Only allow dates in a particular range
Data Validation - Only allow
Only allow dates that are weekdays
Data Validation - Only allow
Only allow dates that are weekends
Data Validation - Only allow
Only allow entries in a particular format
Data Validation - Only allow
Only allow numbers
Data Validation - Only allow
Only allow numbers in a particular range
Data Validation - Only allow
Only allow percentages
Data Validation - Only allow
Only allow text
Data Validation - Only allow
Only allow times
Data Validation - Only allow
Only allow unique values no duplicates
Data Validation - Only allow
Only allow values whose sum is restricted
Data Validation - Only allow
Only allow yes or no
Data Validation - Only allow
Remove last n characters
Text - Remove
Remove one word
Text - Remove
Remove unwanted characters
Text - Remove
Replace one character with another
Text - Replace
Replace one word with another
Text - Replace
Replace text by matching
Text - Replace
Replace text by position
Text - Replace
Return a date in a particular format
Date - Display
Return a date in US date format
Date - Display
Return a list of non blank items
Other - Other
Return a list of unique values
Other - Other
Return a list of unique values ignoring blanks
Other - Other
Return a number reduced by 10 percent
Number - Return
Return a persons age in years
Date - Display
Return a persons age in years months days
Date - Display
Return a substring
Text - Return
Return an array of worksheet names
Other - Other
Return every fourth entry in a list
Text - Return
Return numbers to the nearest fraction
Number - Display
Return random characters
Text - Display
Return random numbers between 1 and 25
Number - Display
Return the 3rd monday in a month
Date - Display
Return the acronym from a text string
Text - Return
Return the business days
Date - Display
Return the current date
Date - Display
Return the current date and time
Date - Display
Return the current day
Date - Display
Return the current month
Date - Display
Return the current quarter
Date - Display
Return the current time
Time - Display
Return the current year
Date - Display
Return the date from a date and time
Date - Display
Return the date of the monday in the current week
Date - Display
Return the date of the monday in the next week
Date - Display
Return the date of the monday in the previous week
Date - Display
Return the day from date
Date - Return
Return the day name
Date - Display
Return the decimal part of a number
Number - Return
Return the digits in reverse order
Number - Return
Return the first business day of the year
Date - First
Return the first day of the current month
Date - First
Return the first day of the next month
Date - First
Return the first day of the previous month
Date - First
Return the first letter of each word
Text - Return
Return the first monday of the current month
Date - First
Return the first monday of the next month
Date - First
Return the first monday of the previous month
Date - First
Return the first name from a full name
Text - Return
Return the first weekday of the month
Date - First
Return the first weekday of the year
Date - First
Return the first word
Text - Return
Return the integer part of a number
Number - Return
Return the last business day of the year
Date - Last
Return the last day of the current month
Date - Last
Return the last day of the current quarter
Date - Last
Return the last day of the next month
Date - Last
Return the last day of the previous month
Date - Last
Return the last monday of the current month
Date - Last
Return the last monday of the next month
Date - Last
Return the last monday of the previous month
Date - Last
Return the last name from a full name
Text - Return
Return the last weekday of the month
Date - Last
Return the last weekday of the year
Date - Last
Return the last word
Text - Return
Return the longest string in a column
Text - Return
Return the middle name from a full name
Text - Return
Return the month from a date
Date - Return
Return the most frequently occurring word
Text - Return
Return the next business day
Date - Return
Return the next friday
Date - Return
Return the next monday
Date - Return
Return the next working day
Date - Return
Return the non blank items in a list
Other - Other
Return the nth business day of the year
Date - Return
Return the nth day of the year
Date - Return
Return the nth word
Text - Return
Return the number corresponding to a given month
Date - Display
Return the number equivalent for a number written as text
Text - Return
Return the number from a number and text
Text - Return
Return the percentage change
Number - Display
Return the previous friday
Date - Return
Return the previous monday
Date - Return
Return the second word
Text - Return
Return the shortest string in a column
Text - Return
Return the text converted to sentence case
Text - Return
Return the time elapsed between 2 times
Time - Display
Return the time from a date and time
Time - Display
Return the time rounded to the nearest 15 minutes
Time - Display
Return the value from the cell above
Text - Return
Return the week number of the current date
Date - Return
Return the word equivalent for a numerical number
Text - Return
Return the words in reverse order
Text - Return
Return the workbook name from a full path
Other - Other
Return the working hours between 2 dates
Time - Display
Return the working hours between 2 times
Time - Display
Return the year from a date
Date - Return
Return two strings joined together
Text - Display
Round a number down
Number - Round
Round a number down to the nearest 100
Number - Round
Round a number down to the nearest 5
Number - Round
Round a number down to the nearest multiple
Number - Round
Round a number to n significant figures
Number - Round
Round a number up
Number - Round
Round a number up to the nearest 100
Number - Round
Round a number up to the nearest 5
Number - Round
Round a number up to the nearest multiple
Number - Round
Shade cells between 2 dates
Formatting - Shade all
Shade cells between 2 numbers
Formatting - Shade all
Shade cells in a particular row
Formatting - Shade all
Shade cells in alternate rows
Formatting - Shade all
Shade cells that are blank
Formatting - Shade all
Shade cells that are errors
Formatting - Shade all
Shade cells that are even numbers
Formatting - Shade all
Shade cells that are negative numbers
Formatting - Shade all
Shade cells that are not errors
Formatting - Shade all
Shade cells that are numbers
Formatting - Shade all
Shade cells that are odd numbers
Formatting - Shade all
Shade cells that are positive numbers
Formatting - Shade all
Shade cells that contain a text string
Formatting - Shade all
Shade cells that contain numbers
Formatting - Shade all
Shade cells that do not contain a text string
Formatting - Shade all
Shade cells with dates equal to a value
Formatting - Shade all
Shade cells with dates in the next n days
Formatting - Shade all
Shade cells with duplicate rows
Formatting - Shade all
Shade cells with duplicate values
Formatting - Shade all
Shade cells with formatting
Formatting - Shade all
Shade dates greater than a value
Formatting - Shade all
Shade dates less than a value
Formatting - Shade all
Shade dates that are business days
Formatting - Shade all
Shade dates that are weekdays
Formatting - Shade all
Shade dates that are weekends
Formatting - Shade all
Shade items in a list that appear in a sub list
Formatting - Shade all
Shade positive changes
Formatting - Shade all
Sort into a random order
Other - Other
Sort using a custom list
Other - Other
Sort using one column
Other - Other
Sort using two columns
Other - Other
Subtract business days from a date
Date - Add or Subtract
Subtract business days from a date changing the days of the weekend
Date - Add or Subtract
Subtract business days from a date excluding public holidays
Date - Add or Subtract
Subtract days from a date
Date - Add or Subtract
Subtract hours from a time
Date - Add or Subtract
Subtract minutes from a time
Date - Add or Subtract
Subtract months from a date
Date - Add or Subtract
Subtract seconds from a time
Date - Add or Subtract
Subtract weeks from a date
Date - Add or Subtract
Subtract years from a date
Date - Add or Subtract
Sum across worksheets
Summing - Other
Sum across worksheets with 1 condition
Summing - Other
Sum all the individual digits of a number
Summing - Other
Sum by group
Summing - Other
Sum by month
Summing - Other
Sum cells after multiplying
Summing - Other
Sum cells between 2 dates
Summing - Between
Sum cells between 2 numbers
Summing - Between
Sum cells equal to 2 values
Summing - Equal To
Sum cells equal to 3 or more values
Summing - Equal To
Sum cells equal to a value
Summing - Equal To
Sum cells equal to a value case sensitive
Summing - Equal To
Sum cells greater than a value
Summing - Less Than or Greater Than
Sum cells less than a value
Summing - Less Than or Greater Than
Sum cells not equal to blank
Summing - Not Equal To
Sum cells not equal to errors
Summing - Not Equal To
Sum cells that begin with
Summing - Contain
Sum cells that contain a text string
Summing - Contain
Sum cells that contain a unique text string
Summing - Other
Sum cells that contain even numbers
Summing - Contain
Sum cells that contain n characters
Summing - Other
Sum cells that contain negative numbers
Summing - Contain
Sum cells that contain numbers
Summing - Other
Sum cells that contain numbers with 1 condition
Summing - Conditional
Sum cells that contain numbers with multiple conditions
Summing - Conditional
Sum cells that contain odd numbers
Summing - Contain
Sum cells that contain positive numbers
Summing - Contain
Sum cells that contain text
Summing - Other
Sum cells that contain unique numbers
Summing - Other
Sum cells that do not contain a text string
Summing - No Contain
Sum cells that do not contain errors
Summing - Other
Sum cells that end with
Summing - Contain
Sum cells that meet 1 condition
Summing - Other
Sum cells that meet either condition
Summing - Other
Sum cells that meet multiple conditions
Summing - Other
Sum cells using array formula
Summing - Other
Sum cells with formatting
Summing - Other
Sum cells with OR criteria
Summing - Other
Sum cells with shading
Summing - Other
Sum comma delimited numbers
Summing - Other
Sum entire column
Summing - Other
Sum entire row
Summing - Other
Sum every n cells in a column
Summing - Other
Sum every n cells in a range
Summing - Other
Sum every n cells in a row
Summing - Other
Sum numbers
Summing - Other
Sum running total
Summing - Other
Sum the last n numbers
Summing - Other
Sum the n largest numbers
Summing - Other
Sum the n smallest numbers
Summing - Other
Test if a cell contains 1 text string
Conditional - If
Test if a cell contains 2 text strings
Conditional - If
Test if a cell is between 2 dates
Date - Test
Test if a cell is between 2 numbers
Number - Test
Test if a cell is blank
Conditional - If
Test if a cell is greater than 1 value
Conditional - If
Test if a cell is less than 1 value
Conditional - If
Test if a cell is not blank
Conditional - If
Test if a year is a leap year
Date - Test

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