MMULT function

Excel » Functions » Math and trigonometry » MMULT function »

Get date ranges from a schedule

The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]

Count rows with data

The formula in cell B17 counts rows in cell range B3:D17 when at least one cell per row contains data. […]

Count cells containing text from list

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

Filter records that contain numeric values

Liam asks: Hello Oscar, What code is needed to cause cells in Columns F - I to fill with the […]

Count overlapping days across multiple date ranges

NC asks: Thanks a tonne, Oscar. It took me about 8 hours to work through this formula piece by piece, […]

Count overlapping days in multiple date ranges

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

Dynamic scoreboard

Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]

Working with overlapping date ranges

Today's blog post is about date ranges, the techniques demonstrated here can also be applied to time or other numerical […]

Find numbers closest to sum

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

How to use the MMULT function

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

Search each column for a string each and return multiple records – OR logic

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

Advanced formulas

Concatenate

Based on a condition

Unique distinct values

Drop-down list

Join without TEXTJOIN

Lookup & return values

Compare

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Records in Excel tables

Two Excel tables

Two price lists

Records in two tables

Common records

Missing values two cols

Common text 2 ranges

Missing text 2 ranges

Update recent values

Sum unique 2 columns

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Two ranges combined

Count shared values

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

Count values

Pattern in cell value

Overlapping time

Containing any list value

Unique distinct/condition

Count colored cells

Equal values per row

Count overlapping days

Sort count freq. condi.

Count overlap. days(2)

Count overlap. days(1)

Contiguous values

Count students

Inventory consumption

Count filtered table

Groups of each value

Weekday in date range

Weekday date range(2)

Cells between value

Count based on date

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Records in date range

Count cell blocks

Uniq. dist. based dates

Count based on date

Numbers across sheets

Uniq. dist. text in rng

Uniq. dist. rec. date rng

Unique distinct months

Condition past 90 days

Uniq. disti. vals 3 rngs

Uniq. dist. vals 2 rngs

Uniq. dist. nums in rng

Uniq. dist. - date criteria

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Inventory consumption

Search related data

Create date ranges

Weekday in date range

Calc dates in project

Weeks from ranges

Weekday date range(2)

Entries date & time rng

Overlap. date ranges

Random uniq dates

Random dates

Highlight overlap rngs

Records in date range

Count cell blocks

Count overlapping dates

Dates from overlap rngs

Highlight overlap rngs

Overlapping ranges

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Largest based on date

Find min/max date rng

Blank between quarters

Based on month

Items past date

Condition past 90 days

Dupe recs by date

Create date range

Lookup the nearest date

Based on a date range

Sort based on dates

Machine utilization

Date based on wkday

Find latest date in a list

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using critera

Easily identify groups of duplicate rows

From a large data set

Filter duplicate words from a cell range [UDF]

Dupes - date, wk, month

Remove based on week

Dupes from rng contain

Filter dupes begins w.

Validate duplicates

Extract duplicate text values from a range containing both numerical and text values

Sort dupes 2 cols A-Z

Find min and max unique and duplicate numerical values

Dupe recs by date

Sort dupes A-Z

Extract duplicates from a range using excel array formula

Extract a list of duplicates from three columns combined using array formula in excel

Extract a list of duplicates from a column

Extract a list of duplicates from two columns combined

Create a list of duplicates where adjacent cell value meets a condition

How to extract a list of duplicates from a column in excel

Duplicate records

Filter duplicate records

Extract duplicate records

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Adjacent has text

Begins with criterion

Sorted alphabetically

Sorted A->Z

Sorted & no blanks - rng

From a cell range

Uniq. dist. rng condition

From multi-cols (2)

Sorted A-Z from range

From two ranges

Extract text from range

Contains string in rng

Based on a date range

Based on dates

Year - month from dates

Based on date criteria

Extract filtered table

Sums, return unique

Extract & sum condition

From a large data set

Assign randomly unique

Sort count freq. condi.

Sort adj. txt horiz. (1)

Sort dupes 2 cols A-Z

Sort unique A-Z

Sort cell delimiter [VBA]

Sort Excel table [VBA]

5 smallest values

Top values - criteria

Sort based on proximity

Sort dates - criteria

Vlookup and return multiple values

5 easy ways

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup criteria rng

Vlookup criteria rng (2)

Vlookup rng - records

Vlook col - return rng

Formula categories

Count

Dates

Extract