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