'COUNTIFS function' category
Get date ranges from a schedule
This article demonstrates ways to extract names and corresponding populated date ranges from a schedule using Excel 365 and earlier […]
This article demonstrates ways to extract names and corresponding populated date ranges from a schedule using Excel 365 and earlier […]
Count cells containing text from list
Table of Contents Count cells containing text from list Count entries based on date and time Count cells with text […]
Table of Contents Count cells containing text from list Count entries based on date and time Count cells with text […]
INDEX MATCH – multiple results
This article demonstrates how to work with multiple criteria using INDEX and MATCH functions. Table of Contents INDEX MATCH - […]
This article demonstrates how to work with multiple criteria using INDEX and MATCH functions. Table of Contents INDEX MATCH - […]
How to use Pivot Tables – Excel’s most powerful feature and also least known
A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.
A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.
Working with overlapping date ranges
This article demonstrates formulas that calculate the number of overlapping ranges for all ranges, finds the most overlapped range and […]
This article demonstrates formulas that calculate the number of overlapping ranges for all ranges, finds the most overlapped range and […]
Search for a sequence of values
This article demonstrates array formulas that identify two search values in a row or in a sequence. The image above […]
This article demonstrates array formulas that identify two search values in a row or in a sequence. The image above […]
Merge tables based on a condition
This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]
This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]
Identify rows of overlapping records
This article demonstrates a formula that points out row numbers of records that overlap the current record based on a […]
This article demonstrates a formula that points out row numbers of records that overlap the current record based on a […]
Prevent duplicate records in a worksheet
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
How to use the COUNTIFS function
Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.
Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.
How to use VLOOKUP/XLOOKUP with multiple conditions
I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]
I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting formulas. The […]
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting formulas. The […]
Working with Relational Tables in Excel
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]
Excel 2010 has a PowerPivot feature and DAX formulas that let you work with multiple tables of data. You can […]
Lookup multiple values across columns and return a single value
Table of Contents Lookup multiple values across columns and return a single value Lookup using multiple conditions Lookup a date […]
Table of Contents Lookup multiple values across columns and return a single value Lookup using multiple conditions Lookup a date […]
Unique distinct records sorted based on count or frequency
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
Working with Conditional Formatting formulas
In this post I am going to try to explain formula basics in conditional formatting. It is really good if […]
In this post I am going to try to explain formula basics in conditional formatting. It is really good if […]
Extract unique distinct values from an Excel Table filtered list
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
This article demonstrates two formulas that extract distinct values from a filtered Excel Table, one formula for Excel 365 subscribers […]
How to compare two data sets
Table of Contents How to compare two data sets - Excel Table and autofilter Filter shared records from two tables […]
Table of Contents How to compare two data sets - Excel Table and autofilter Filter shared records from two tables […]
How to highlight differences and common values in lists
This article demonstrates techniques to highlight differences and common values across lists. What's on this page How to highlight differences […]
This article demonstrates techniques to highlight differences and common values across lists. What's on this page How to highlight differences […]
Count unique distinct records
Table of Contents Count unique distinct records Count records with possible blank rows in data set How to count blank […]
Table of Contents Count unique distinct records Count records with possible blank rows in data set How to count blank […]
Compare tables: Filter records occurring only in one table
Table of Contents Compare tables: Filter records occurring only in one table Compare two lists and filter unique values where […]
Table of Contents Compare tables: Filter records occurring only in one table Compare two lists and filter unique values where […]
Extract dates from overlapping date ranges
The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]
The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]
Split data across multiple sheets – VBA
Table of Contents Split data across multiple sheets - VBA Add values to worksheets based on a condition - VBA […]
Table of Contents Split data across multiple sheets - VBA Add values to worksheets based on a condition - VBA […]
Match two criteria and return multiple records
This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]
This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]
How to return a value if lookup value is in a range
In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]
In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]
Extract a list of duplicates from a column
The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]
The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]
How to create date ranges in Excel
Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 […]
Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 […]
Count unique distinct values
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
Calculate machine utilization
This article explains how to calculate an overlapping time ranges across multiple days. This can be very useful in situations […]
This article explains how to calculate an overlapping time ranges across multiple days. This can be very useful in situations […]
Filter unique distinct records
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values