__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 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 |