## 'MMULT function' category

This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]

This article demonstrates ways to extract names and corresponding populated date ranges from a schedule using Excel 365 and earlier […]

Table of Contents Count rows with data Count non-empty rows Count cells between two values Count cells based on a […]

The worksheet above shows four different time ranges in column B and C, the formula in cell C10 counts the […]

What's on this page How to extract numbers from a cell value - Excel 2016 Sort and return unique distinct […]

Table of Contents Count cells containing text from list Count entries based on date and time 1. Count cells containing […]

This article demonstrates formulas that let you perform lookups using two or more conditions. The image above shows two conditions […]

This article demonstrates a formula that extracts unique values from a column also considering upper and lower characters (case sensitive). […]

This article describes a formula that returns all rows containing at least one digit 0 (zero) to 9. What's on […]

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

This post demonstrates a formula in cell D16 that counts overlapping dates across multiple date ranges. The date ranges are […]

In this article, I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The […]

In the previous post I explained how to count overlapping dates comparing a single date range against multiple date ranges. […]

The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]

This article demonstrates a scoreboard, displayed to the left, that sorts contestants based on total scores and refreshes instantly each […]

This article demonstrates formulas that calculate the number of overlapping ranges for all ranges, finds the most overlapped range and […]

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]

This article explains how to create a formula that returns the earliest (smallest) and the latest (largest) date of overlapping […]

The MMULT function calculatesÂ the matrix product of two arrays, an array as the same number of rows as array1 and […]

This article explains how to perform multiple lookups based on values in one cell with a delimiting character using a […]

RU asks: Can you please suggest if i want to find out the rows with fixed value in "First Name" […]

This article demonstrates two ways to extract unique and unique distinct rows from a given cell range. The first one […]

Sean asks: The good thing about this formula is that it is short and easy to remember. The main drawback […]

This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]

Jerome asks, in this blog post Search for multiple text strings in multiple cells in excel : If the list […]

Question: Can expand this equation set into more than two colums of data, say if I had a first, middle […]

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

Question: I want to search two columns with two search strings? The strings can be anywhere in these two columns […]

This article describes how to count unique distinct values. What are unique distinct values?Â They are all values but duplicates are […]

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

This article demonstrates ways to extract shared values in different cell ranges, two and three cell ranges. The Excel 365 […]