'SUBTOTAL function' category
How to use the SUBTOTAL function
What is the SUBTOTAL function? The SUBTOTAL function calculates a subtotal based on a cell range. The picture above shows […]
What is the SUBTOTAL function? The SUBTOTAL function calculates a subtotal based on a cell range. The picture above shows […]
Filter duplicate values based on criteria
This article demonstrates formulas and Excel tools that extract duplicates based on three conditions. The first and second condition is […]
This article demonstrates formulas and Excel tools that extract duplicates based on three conditions. The first and second condition is […]
How to use the Subtotal tool
The Subtotal feature lets you insert totals and grand totals automatically, this feature was added to Excel 2010 and is […]
The Subtotal feature lets you insert totals and grand totals automatically, this feature was added to Excel 2010 and is […]
Highlight unique values in a filtered Excel table
Table of contents Highlight unique values in a filtered Excel table Highlight unique values and unique distinct values in a […]
Table of contents Highlight unique values in a filtered Excel table Highlight unique values and unique distinct values in a […]
Count Conditionally Formatted cells
This article explains how to count cells highlighted with Conditional Formatting (CF). The image above shows data in cell range […]
This article explains how to count cells highlighted with Conditional Formatting (CF). The image above shows data in cell range […]
Count cells based on background color
This article demonstrates techniques on how to count cells based on the background color. I will also demonstrate user defined […]
This article demonstrates techniques on how to count cells based on the background color. I will also demonstrate user defined […]
Highlight duplicates in a filtered Excel Table
The image above demonstrates a conditional formatting formula applied to an Excel Table containing random data. The Excel Table has […]
The image above demonstrates a conditional formatting formula applied to an Excel Table containing random data. The Excel Table has […]
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 […]
Populate drop down list with filtered Excel Table values
This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
Count unique distinct values in a filtered Excel defined Table
This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]
This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]
Extract unique distinct values in a 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 […]
Extract unique distinct values based on a filtered Excel defined Table
This blog post demonstrates how to filter unique distinct values from an Excel table dynamically. When you change or add […]
This blog post demonstrates how to filter unique distinct values from an Excel table dynamically. When you change or add […]
Most frequent value between two dates
I will in this article show you how to extract the most frequent value (text or number) between two dates […]
I will in this article show you how to extract the most frequent value (text or number) between two dates […]
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