Complete List

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 weekendsDate - Add or Subtract
Add days to a date excluding weekends and changing the days of the weekendDate - Add or Subtract
Add days to a date excluding weekends and public holidaysDate - Add or Subtract
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 dateDate - Add or Subtract
Add working days to a date changing the days of the weekendDate - Add or Subtract
Add working days to a date excluding public holidaysDate - 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 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 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
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 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 mondays between 2 datesDate - Number of Days
Number of months between 2 datesDate - Number of Months
Number of occurrences of a particular day of the weekDate - 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 weeks between 2 datesDate - Number of
Number of working daysDate - Number of
Number of working days between 2 datesDate - Number of
Number of working days in a particular monthDate - Number of
Number of working days in a particular yearDate - Number of
Number of working days left in the current monthDate - Number of
Number of working days left in the current yearDate - Number of
Number of working days that have passed in the current monthDate - Number of
Number of working days that have passed in the current yearDate - Number of
Number of working hours between 2 datesTime - Number of
Number of working hours between 2 timesTime - 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 date in a particular formatDate - Display
Return a date in US date formatDate - Display
Return a persons age in yearsDate - Display
Return a substringText - Return
Return all non blank items in a listOther - Other
Return all numbers reduced by 10 percentNumber - 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 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 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 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 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 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 - Display
Return the next working dayDate - Display
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 from a number and textText - Return
Return the percentage changeNumber - Display
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 - Display
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
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
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
Date - Add or Subtract
Add days to a date excluding weekends and changing the days of the weekend
Date - Add or Subtract
Add days to a date excluding weekends and public holidays
Date - Add or Subtract
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
Date - Add or Subtract
Add working days to a date changing the days of the weekend
Date - Add or Subtract
Add working days to a date excluding public holidays
Date - Add or Subtract
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 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
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 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 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 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
Number of weekend days between 2 dates
Date - Number of
Number of weekend days in a particular month
Date - Number of
Number of weekend days in a particular year
Date - Number of
Number of weeks between 2 dates
Date - Number of
Number of working days
Date - Number of
Number of working days between 2 dates
Date - Number of
Number of working days in a particular month
Date - Number of
Number of working days in a particular year
Date - Number of
Number of working days left in the current month
Date - Number of
Number of working days left in the current year
Date - Number of
Number of working days that have passed in the current month
Date - Number of
Number of working days that have passed in the current year
Date - Number of
Number of working hours between 2 dates
Time - Number of
Number of working hours between 2 times
Time - Number of
Number of years between 2 dates
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 persons age in years
Date - Display
Return a substring
Text - Return
Return all non blank items in a list
Other - Other
Return all numbers reduced by 10 percent
Number - 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 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 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 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 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 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 - Display
Return the next working day
Date - Display
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 from a number and text
Text - Return
Return the percentage change
Number - Display
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 - Display
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
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

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