Basic text sort formula in Excel
To dynamically sort text values in alphabetical order, you can use use a formula based … Read More
Example of COUNTIFS with variable table column in Excel
To use COUNTIFS with a variable table column, you can use INDEX and MATCH to … Read More
Two ways to sum time over 30 minutes in Excel
To sum the total amount of time over 30 minutes, given a set of times … Read More
Count times in a specific range in Excel
This tutorial shows how to Count times in a specific range in Excel using example … Read More
Count dates in current month in Excel
This tutorial shows how to Count dates in current month in Excel using example below.… Read More
Excel Rank if formula Example
This tutorials shows how to rank items in a list using one or more criteria … Read More
Highlight duplicate rows in Excel
This tutorial shows how to Highlight duplicate rows in Excel using the example below;
Formula
… Read MoreIF with wildcards in Excel
This tutorial shows how to calculate IF with wildcards in Excel using the example below;… Read More
Break ties with helper column and COUNTIF in Excel
This tutorial shows how to Break ties with helper column and COUNTIF in Excel using … Read More
Count cells between two numbers in Excel
This tutorial shows how to Count cells between two numbers in Excel using the example … Read More
Count cells that do not contain many strings in Excel
This tutorial shows how to Count cells that do not contain many strings in Excel … Read More
Count cells that do not contain in Excel
This tutorial shows how to Count cells that do not contain in Excel using the … Read More
Count cells that contain text in Excel
This tutorial shows how to Count cells that contain text in Excel using the example … Read More
Count cells between dates in Excel
This tutorial shows how to Count cells between dates in Excel using the example below;… Read More
Count cells not equal to many things in Excel
This tutorial shows how to Count cells not equal to many things in Excel using … Read More
Count if two criteria match in Excel
This tutorial shows how to Count if two criteria match in Excel using the example … Read More
Count items in list in Excel
This tutorial shows how to Count items in list in Excel using the example below;… Read More
Count numbers by range with COUNTIFS in Excel
This tutorial shows how to Count numbers by range with COUNTIFS in Excel using the … Read More
Count paired items in listed combinations in Excel
This tutorial shows how to Count paired items in listed combinations in Excel using the … Read More
COUNTIFS with multiple criteria and OR logic in Excel
This tutorial shows how to COUNTIFS with multiple criteria and OR logic in Excel using … Read More