BetterSolutions.com
BetterSolutions.com
Resources
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Addins
Office Add-ins for Excel
Office Add-ins for Word
Consultancy
Macros, Templates and EUDAs
TypeScript and JavaScript
Development
Office JS Add-ins and Scripts
End User Programming
Support
VSTO and .NET Migration
Troubleshooting
Training
Microsoft 365 Integration
Please Contact Us Today for a FREE Consultation
Excel
Add-ins
Best Practices
Cells Ranges
Charts
Conditional Format
Data Analysis
Data Validation
Dates Times
Search Excel ...
Functions
User Defined
Formulas
Formatting
Finance
Illustrations
Importing
Layout
Our Services ...
Macros
Named Ranges
Options
Pivot Tables
Power Query
Protection
Reviewing
Ribbon
Find Add-ins ...
Rows Columns
Shortcut Keys
Tables
Templates
Track Changes
Workbooks
Worksheets
XML
Contact Us ...
Word
Add-ins
Bookmarks
Building Blocks
Bullets
Characters
Charts
Content Controls
Design
Search Word ...
Documents
Fields
Illustrations
Importing
Layout
Macros
Mailings
Numbering
Our Services ...
Options
Outlines
Pages
Paragraphs
Protection
References
Reviewing
Ribbon
Find Add-ins ...
Sections
Shortcut Keys
Styles
Tables
Templates
Text Boxes
Track Changes
XML
Contact Us ...
PowerPoint
Add-ins
Animation
Bullets
Characters
Charts
Design
Handouts
Illustrations
Search PowerPoint ...
Importing
Layout
Macros
Notes
Numbering
Options
Outlines
Paragraphs
Our Services ...
Presentations
Protection
References
Reviewing
Ribbon
Sections
Shortcut Keys
Slide Show
Find Add-ins ...
Slides
Tables
Templates
Text Boxes
Track Changes
Transitions
Video
XML
Contact Us ...
Outlook
Add-ins
Address Book
Alerts
Appointments
Calendar
Contacts
Events
Exchange
Search Outlook ...
Folders
Forms
Groups
HTML
Illustrations
Importing
Journal
Macros
Our Services ...
Mail
Meetings
Notes
OneDrive
OneNote
Options
People
Proofing
Find Add-ins ...
Ribbon
Rules
Search
SharePoint
Shortcut Keys
Tasks
Web Client
XML
Contact Us ...
VBA
Add-ins
Arrays
Best Practices
Class Modules
Code Snippets
Collections
Controls
Databases
Search VBA ...
Data Types
Dates Times
Debugging
Enumerations
Error Handling
Events
Files Directories
Functions
Our Services ...
Macros
MsgBox
Numbers
Options
References
Ribbon
Shortcut Keys
SQL
Find Add-ins ...
Strings
Subroutines
Syntax
Userforms
Variables
Visual Basic Editor
Web Interaction
XML
Contact Us ...
C#
.NET Library
Arrays
Best Practices
Classes
Collections
Databases
Data Types
Dates Times
Search C# ...
Debugging
Excel Interop
Error Handling
Files Directories
Generics
Interfaces
MessageBox
Numbers
Our Services ...
Projects
Serialization
Strings
Structures
Syntax
Threading
Variables
VBA Migration
Find Add-ins ...
Visual Studio
VSTO Add-ins
Web Add-ins
Web Development
Web Services
Windows Forms
WPF Forms
XML
Contact Us ...
JS
Arrays
Custom Functions
Data Types
Dates Times
Debugging
Dialog Boxes
Error Handling
Excel API
Search JavaScript ...
Express Backend
Fluent UI
Functions
HTML Pages
Microsoft Graph
Node JS Runtime
Numbers
Objects
Our Services ...
Office Add-ins
Office Events
Office Manifest
Office Scripts
Outlook API
PowerPoint API
React Library
Ribbon Commands
Find Add-ins ...
Strings
Syntax
Task Panes
TypeScript
Variables
Visual Studio Code
Word API
Yeoman Generator
Contact Us ...
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
Error Types ...
Complete List
Categories ...
Counting Formulas
Summing Formulas
Lookup Formulas
Inserting ...
Calculation ...
Auditing ...
Error Checking ...
Dynamic Formulas ...
Array Formulas ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 01 November 2024
01 November 2024
Complete List
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 and changing the days of the weekend*
Placeholder
Add days to a date excluding weekends and public holidays*
Placeholder
Add days to a date excluding weekends*
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 decimal hours to time*
Placeholder
Add decimal minutes to time*
Placeholder
Add decimal seconds to time*
Placeholder
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 changing the days of the weekend*
Placeholder
Add working days to a date excluding public holidays*
Placeholder
Add working days to a date*
Placeholder
Add years to a date
Date - Add or Subtract
Average cells
Number - Average
Average cells after subtraction
Number - Average
Average cells ignoring duplicates
Number - Average
Average cells ignoring zeros
Number - Average
Average cells in a table when a column meets multiple conditions
Number - Average
Average cells that are not errors
Number - Average
Average cells that are not hidden
Number - Average
Average cells using the n largest numbers
Number - Average
Average cells using the n last numbers
Number - Average
Average cells using the n smallest numbers
Number - Average
Average cells using weighted average
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 decimal hours to time
Time - Convert
Convert decimal minutes to time
Time - Convert
Convert decimal seconds to time
Time - Convert
Convert hours to time*
Placeholder
Convert minutes to time*
Placeholder
Convert numbers to text
Text - Convert
Convert seconds to time*
Placeholder
Convert time to hours
Time - Convert
Convert time to minutes
Time - Convert
Convert time to seconds
Time - Convert
Convert time to time zone
Time - Convert
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells equal to this or that
Counting - Equal To
Count cells in a table when a column is greater than a value
Counting - Table
Count cells in a table when a column is less than a value
Counting - Table
Count cells in a table when a column is unique with 1 condition
Counting - Are
Count cells in a table when a column meets 1 condition
Counting - Table
Count cells in a table when a column meets multiple conditions
Counting - Table
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 a value
Counting - Not Equal To
Count cells not equal to one of many
Counting - Not Equal To
Count cells that are blank
Counting - Equal To
Count cells that are dates
Counting - Equal To
Count cells that are dates and either x or y
Counting - Contain
Count cells that are dates and equal to a value
Counting - Contain
Count cells that are dates and in a particular month
Counting - Contain
Count cells that are dates and in a particular year
Counting - Contain
Count cells that are dates and not between 2 dates
Counting - Contain
Count cells that are dates and not equal to a value
Counting - Contain
Count cells that are dates and unique
Counting - Contain
Count cells that are dates between 2 dates
Counting - Contain
Count cells that are dates by day of week
Counting - Other
Count cells that are errors
Counting - Contain
Count cells that are hidden
Counting - Other
Count cells that are not blank
Counting - Not Equal To
Count cells that are not dates
Counting - Not Equal To
Count cells that are not errors
Counting - Not Equal To
Count cells that are not hidden
Counting - Not Equal To
Count cells that are not numbers
Counting - Contain
Count cells that are not text
Counting - Not Equal To
Count cells that are not text or numbers
Counting - Contain
Count cells that are numbers
Counting - Contain
Count cells that are numbers and do not equal a value
Counting - Contain
Count cells that are numbers and do not equal either x or y
Counting - Contain
Count cells that are numbers and either x or y
Counting - Contain
Count cells that are numbers and equal to a value
Counting - Contain
Count cells that are numbers and even
Counting - Contain
Count cells that are numbers and greater than a value
Counting - Contain
Count cells that are numbers and less than a value
Counting - Contain
Count cells that are numbers and negative
Counting - Contain
Count cells that are numbers and odd
Counting - Are
Count cells that are numbers and positive
Counting - Contain
Count cells that are numbers and unique
Counting - Are
Count cells that are numbers in a range
Counting - Other
Count cells that are numbers with leading zeros
Counting - Other
Count cells that are text
Counting - Are
Count cells that are text and begin with
Counting - Contain
Count cells that are text and contain a value
Counting - Other
Count cells that are text and contain a value case sensitive
Counting - Other
Count cells that are text and contain either x or y
Counting - Contain
Count cells that are text and do not begin with
Counting - Contain
Count cells that are text and do not contain a value
Counting - Other
Count cells that are text and do not end with
Counting - Contain
Count cells that are text and do not equal a value
Counting - Other
Count cells that are text and do not equal either x or y
Counting - Other
Count cells that are text and either x or y
Counting - Other
Count cells that are text and end with
Counting - Other
Count cells that are text and equal to a value
Counting - Contain
Count cells that are text and equal to a value case sensitive
Counting - Contain
Count cells that are text and n characters long
Counting - Contain
Count cells that are text and over n characters long
Counting - Other
Count cells that are text and unique
Counting - Are
Count cells that are visible
Counting - Other
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count differences between 2 cell ranges
Counting - Conditional
Count occurrences in entire workbook
Counting - Other
Count or sum variance
Counting - Other
Count substring occurrences
Counting - Other
Count times in a particular range
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
Counting - Other
Count unique dates
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 cells
Counting - Other
Count visible columns
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
Count whole numbers only
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 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 business days*
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 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 weekend days*
Placeholder
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 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 days*
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*
Placeholder
Only allow characters in uppercase*
Placeholder
Only allow dates in a particular range*
Placeholder
Only allow dates in a particular year
Data Validation - Only allow
Only allow dates in the current year
Data Validation - Only allow
Only allow dates in the next 30 days
Data Validation - Only allow
Only allow dates that are weekdays*
Placeholder
Only allow dates that are weekends
Data Validation - Only allow
Only allow dates*
Placeholder
Only allow entries in a particular format*
Placeholder
Only allow numbers in a particular range*
Placeholder
Only allow numbers that are whole numbers
Data Validation - Only allow
Only allow numbers*
Placeholder
Only allow percentages that are whole numbers
Data Validation - Only allow
Only allow percentages*
Placeholder
Only allow text in uppercase*
Placeholder
Only allow text*
Placeholder
Only allow times*
Placeholder
Only allow unique values no duplicates*
Placeholder
Only allow values from a predefined list*
Placeholder
Only allow values that are not in a predefined list
Data Validation - Only allow
Only allow values whose sum is restricted*
Placeholder
Only allow yes or no*
Placeholder
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 from a date string
Date - Display
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 from a date string
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 a 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 current quarter
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 day of the previous quarter
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 day of the previous quarter
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 most recent Friday*
Date - Return
Return the most recent Monday*
Date - 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 a month
Date - Return
Return the nth day of a week
Date - Return
Return the nth day of a 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 business day
Date - Return
Return the previous Friday
Date - Return
Return the previous Monday
Date - Return
Return the previous working day
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 dates
Formatting - Shade all
Shade cells that are dates and business days
Formatting - Shade all
Shade cells that are dates and greater than a value
Formatting - Shade all
Shade cells that are dates and less than a value
Formatting - Shade all
Shade cells that are dates and weekdays
Formatting - Shade all
Shade cells that are dates and weekends
Formatting - Shade all
Shade cells that are dates in the next n days
Formatting - Shade all
Shade cells that are errors
Formatting - Shade all
Shade cells that are not errors
Formatting - Shade all
Shade cells that are not numbers
Formatting - Shade all
Shade cells that are not text
Formatting - Shade all
Shade cells that are numbers
Formatting - Shade all
Shade cells that are numbers and even
Formatting - Shade all
Shade cells that are numbers and greater than a value
Formatting - Shade all
Shade cells that are numbers and less than a value
Formatting - Shade all
Shade cells that are numbers and negative
Formatting - Shade all
Shade cells that are numbers and odd
Formatting - Shade all
Shade cells that are numbers and positive
Formatting - Shade all
Shade cells that are text
Formatting - Shade all
Shade cells that are text and do not contain specific text
Formatting - Shade all
Shade cells with dates equal to a value
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 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 by year
Summing - Other
Sum cells in a table when a column contains n characters
Summing - Table
Sum cells in a table when a column does not contain a value
Summing - Table
Sum cells in a table when a column is either x or y
Summing - Table
Sum cells in a table when a column is equal to 2 values
Summing - Table
Sum cells in a table when a column is equal to 3 or more values
Summing - Table
Sum cells in a table when a column is equal to a value
Summing - Table
Sum cells in a table when a column is equal to a value case sensitive
Summing - Table
Sum cells in a table when a column is not blank
Summing - Table
Sum cells in a table when a column is text
Summing - Table
Sum cells in a table when a column is text and begins with
Summing - Table
Sum cells in a table when a column is text and ends with
Summing - Table
Sum cells in a table when a column meets 1 condition
Summing - Table
Sum cells in a table when a column meets multiple conditions
Summing - Table
Sum cells that are not errors
Summing - Other
Sum cells that are not hidden
Summing - Other
Sum cells that are numbers
Summing - Other
Sum cells that are numbers after multiplying
Summing - Other
Sum cells that are numbers and even
Summing - Other
Sum cells that are numbers and greater than a value
Summing - Other
Sum cells that are numbers and less than a value
Summing - Other
Sum cells that are numbers and negative
Summing - Other
Sum cells that are numbers and odd
Summing - Other
Sum cells that are numbers and positive
Summing - Other
Sum cells that are numbers and unique
Summing - Other
Sum cells that are numbers in a range
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
Sum visible rows in a filtered column
Summing - Other
Sum visible rows with 1 condition
Summing - Other
Sum visible rows with multiple conditions
Summing - Other
Sum whole numbers only
Summing - Other
Test if a cell begins with x y or z
Conditional - If
Test if a cell contains 1 text string
Conditional - If
Test if a cell contains 1 word
Conditional - If
Test if a cell contains 2 text strings
Conditional - If
Test if a cell contains 2 words
Conditional - If
Test if a cell equals 1 value
Conditional - If
Test if a cell equals this
Conditional - If
Test if a cell equals this and another cells equals that
Conditional - If
Test if a cell equals this or that
Conditional - If
Test if a cell equals x y or z
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 month has 30 days
Date - Test
Test if a month has 31 days
Date - Test
Test if a year is a leap year
Date - Test
Test if not blank multiple cells
Conditional - If
Test if this and that*
Conditional - If
Test if this or that*
Conditional - If
Test if with wildcards
Conditional - If
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 and changing the days of the weekend*
Placeholder
Add days to a date excluding weekends and public holidays*
Placeholder
Add days to a date excluding weekends*
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 decimal hours to time*
Placeholder
Add decimal minutes to time*
Placeholder
Add decimal seconds to time*
Placeholder
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 changing the days of the weekend*
Placeholder
Add working days to a date excluding public holidays*
Placeholder
Add working days to a date*
Placeholder
Add years to a date
Date - Add or Subtract
Average cells
Number - Average
Average cells after subtraction
Number - Average
Average cells ignoring duplicates
Number - Average
Average cells ignoring zeros
Number - Average
Average cells in a table when a column meets multiple conditions
Number - Average
Average cells that are not errors
Number - Average
Average cells that are not hidden
Number - Average
Average cells using the n largest numbers
Number - Average
Average cells using the n last numbers
Number - Average
Average cells using the n smallest numbers
Number - Average
Average cells using weighted average
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 decimal hours to time
Time - Convert
Convert decimal minutes to time
Time - Convert
Convert decimal seconds to time
Time - Convert
Convert hours to time*
Placeholder
Convert minutes to time*
Placeholder
Convert numbers to text
Text - Convert
Convert seconds to time*
Placeholder
Convert time to hours
Time - Convert
Convert time to minutes
Time - Convert
Convert time to seconds
Time - Convert
Convert time to time zone
Time - Convert
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells equal to this or that
Counting - Equal To
Count cells in a table when a column is greater than a value
Counting - Table
Count cells in a table when a column is less than a value
Counting - Table
Count cells in a table when a column is unique with 1 condition
Counting - Are
Count cells in a table when a column meets 1 condition
Counting - Table
Count cells in a table when a column meets multiple conditions
Counting - Table
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 a value
Counting - Not Equal To
Count cells not equal to one of many
Counting - Not Equal To
Count cells that are blank
Counting - Equal To
Count cells that are dates
Counting - Equal To
Count cells that are dates and either x or y
Counting - Contain
Count cells that are dates and equal to a value
Counting - Contain
Count cells that are dates and in a particular month
Counting - Contain
Count cells that are dates and in a particular year
Counting - Contain
Count cells that are dates and not between 2 dates
Counting - Contain
Count cells that are dates and not equal to a value
Counting - Contain
Count cells that are dates and unique
Counting - Contain
Count cells that are dates between 2 dates
Counting - Contain
Count cells that are dates by day of week
Counting - Other
Count cells that are errors
Counting - Contain
Count cells that are hidden
Counting - Other
Count cells that are not blank
Counting - Not Equal To
Count cells that are not dates
Counting - Not Equal To
Count cells that are not errors
Counting - Not Equal To
Count cells that are not hidden
Counting - Not Equal To
Count cells that are not numbers
Counting - Contain
Count cells that are not text
Counting - Not Equal To
Count cells that are not text or numbers
Counting - Contain
Count cells that are numbers
Counting - Contain
Count cells that are numbers and do not equal a value
Counting - Contain
Count cells that are numbers and do not equal either x or y
Counting - Contain
Count cells that are numbers and either x or y
Counting - Contain
Count cells that are numbers and equal to a value
Counting - Contain
Count cells that are numbers and even
Counting - Contain
Count cells that are numbers and greater than a value
Counting - Contain
Count cells that are numbers and less than a value
Counting - Contain
Count cells that are numbers and negative
Counting - Contain
Count cells that are numbers and odd
Counting - Are
Count cells that are numbers and positive
Counting - Contain
Count cells that are numbers and unique
Counting - Are
Count cells that are numbers in a range
Counting - Other
Count cells that are numbers with leading zeros
Counting - Other
Count cells that are text
Counting - Are
Count cells that are text and begin with
Counting - Contain
Count cells that are text and contain a value
Counting - Other
Count cells that are text and contain a value case sensitive
Counting - Other
Count cells that are text and contain either x or y
Counting - Contain
Count cells that are text and do not begin with
Counting - Contain
Count cells that are text and do not contain a value
Counting - Other
Count cells that are text and do not end with
Counting - Contain
Count cells that are text and do not equal a value
Counting - Other
Count cells that are text and do not equal either x or y
Counting - Other
Count cells that are text and either x or y
Counting - Other
Count cells that are text and end with
Counting - Other
Count cells that are text and equal to a value
Counting - Contain
Count cells that are text and equal to a value case sensitive
Counting - Contain
Count cells that are text and n characters long
Counting - Contain
Count cells that are text and over n characters long
Counting - Other
Count cells that are text and unique
Counting - Are
Count cells that are visible
Counting - Other
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count differences between 2 cell ranges
Counting - Conditional
Count occurrences in entire workbook
Counting - Other
Count or sum variance
Counting - Other
Count substring occurrences
Counting - Other
Count times in a particular range
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
Counting - Other
Count unique dates
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 cells
Counting - Other
Count visible columns
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
Count whole numbers only
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 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 business days*
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 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 weekend days*
Placeholder
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 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 days*
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*
Placeholder
Only allow characters in uppercase*
Placeholder
Only allow dates in a particular range*
Placeholder
Only allow dates in a particular year
Data Validation - Only allow
Only allow dates in the current year
Data Validation - Only allow
Only allow dates in the next 30 days
Data Validation - Only allow
Only allow dates that are weekdays*
Placeholder
Only allow dates that are weekends
Data Validation - Only allow
Only allow dates*
Placeholder
Only allow entries in a particular format*
Placeholder
Only allow numbers in a particular range*
Placeholder
Only allow numbers that are whole numbers
Data Validation - Only allow
Only allow numbers*
Placeholder
Only allow percentages that are whole numbers
Data Validation - Only allow
Only allow percentages*
Placeholder
Only allow text in uppercase*
Placeholder
Only allow text*
Placeholder
Only allow times*
Placeholder
Only allow unique values no duplicates*
Placeholder
Only allow values from a predefined list*
Placeholder
Only allow values that are not in a predefined list
Data Validation - Only allow
Only allow values whose sum is restricted*
Placeholder
Only allow yes or no*
Placeholder
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 from a date string
Date - Display
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 from a date string
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 a 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 current quarter
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 day of the previous quarter
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 day of the previous quarter
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 most recent Friday*
Date - Return
Return the most recent Monday*
Date - 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 a month
Date - Return
Return the nth day of a week
Date - Return
Return the nth day of a 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 business day
Date - Return
Return the previous Friday
Date - Return
Return the previous Monday
Date - Return
Return the previous working day
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 dates
Formatting - Shade all
Shade cells that are dates and business days
Formatting - Shade all
Shade cells that are dates and greater than a value
Formatting - Shade all
Shade cells that are dates and less than a value
Formatting - Shade all
Shade cells that are dates and weekdays
Formatting - Shade all
Shade cells that are dates and weekends
Formatting - Shade all
Shade cells that are dates in the next n days
Formatting - Shade all
Shade cells that are errors
Formatting - Shade all
Shade cells that are not errors
Formatting - Shade all
Shade cells that are not numbers
Formatting - Shade all
Shade cells that are not text
Formatting - Shade all
Shade cells that are numbers
Formatting - Shade all
Shade cells that are numbers and even
Formatting - Shade all
Shade cells that are numbers and greater than a value
Formatting - Shade all
Shade cells that are numbers and less than a value
Formatting - Shade all
Shade cells that are numbers and negative
Formatting - Shade all
Shade cells that are numbers and odd
Formatting - Shade all
Shade cells that are numbers and positive
Formatting - Shade all
Shade cells that are text
Formatting - Shade all
Shade cells that are text and do not contain specific text
Formatting - Shade all
Shade cells with dates equal to a value
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 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 by year
Summing - Other
Sum cells in a table when a column contains n characters
Summing - Table
Sum cells in a table when a column does not contain a value
Summing - Table
Sum cells in a table when a column is either x or y
Summing - Table
Sum cells in a table when a column is equal to 2 values
Summing - Table
Sum cells in a table when a column is equal to 3 or more values
Summing - Table
Sum cells in a table when a column is equal to a value
Summing - Table
Sum cells in a table when a column is equal to a value case sensitive
Summing - Table
Sum cells in a table when a column is not blank
Summing - Table
Sum cells in a table when a column is text
Summing - Table
Sum cells in a table when a column is text and begins with
Summing - Table
Sum cells in a table when a column is text and ends with
Summing - Table
Sum cells in a table when a column meets 1 condition
Summing - Table
Sum cells in a table when a column meets multiple conditions
Summing - Table
Sum cells that are not errors
Summing - Other
Sum cells that are not hidden
Summing - Other
Sum cells that are numbers
Summing - Other
Sum cells that are numbers after multiplying
Summing - Other
Sum cells that are numbers and even
Summing - Other
Sum cells that are numbers and greater than a value
Summing - Other
Sum cells that are numbers and less than a value
Summing - Other
Sum cells that are numbers and negative
Summing - Other
Sum cells that are numbers and odd
Summing - Other
Sum cells that are numbers and positive
Summing - Other
Sum cells that are numbers and unique
Summing - Other
Sum cells that are numbers in a range
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
Sum visible rows in a filtered column
Summing - Other
Sum visible rows with 1 condition
Summing - Other
Sum visible rows with multiple conditions
Summing - Other
Sum whole numbers only
Summing - Other
Test if a cell begins with x y or z
Conditional - If
Test if a cell contains 1 text string
Conditional - If
Test if a cell contains 1 word
Conditional - If
Test if a cell contains 2 text strings
Conditional - If
Test if a cell contains 2 words
Conditional - If
Test if a cell equals 1 value
Conditional - If
Test if a cell equals this
Conditional - If
Test if a cell equals this and another cells equals that
Conditional - If
Test if a cell equals this or that
Conditional - If
Test if a cell equals x y or z
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 month has 30 days
Date - Test
Test if a month has 31 days
Date - Test
Test if a year is a leap year
Date - Test
Test if not blank multiple cells
Conditional - If
Test if this and that*
Conditional - If
Test if this or that*
Conditional - If
Test if with wildcards
Conditional - If
© 2024 Better Solutions Limited.
All Rights Reserved.
© 2024
Better Solutions Limited
Top