MMULT function

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

Two price lists

Records in two tables

Common records

Update recent values(2)

Missing values two cols

Update recent values

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

Combine merge

Merge tables

Merge rows - condition

Combine ranges [UDF]

Merge matching rows

Merge 2 cols w. blanks

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

Comma separated vals

Count Conditionally Formatted cells

Count based on color

Count filtered table

Groups of each value

Weekday in date range

Weekday date range(2)

Cells between value

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Count groups in calendar

Uniq. dist. based dates

Count based on date

Numbers across sheets

Cells between values

Most freq/date range

Unique distinct months

Uniq. dist. 2 cols

Unique dist. values

Dates

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Find date range based on a date

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

Overlap rngs - condition

Count groups in calendar

Dates from overlap rngs

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Most freq/date range

Find min/max date rng

Blank between quarters

Dupe vals sorted date

Create date range

Lookup the nearest date

Based on a date range

Machine utilization

Date based on wkday

Find numbers in sum

Numbers closest to sum

Count overlapping days

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Overlap rngs - condition

Based on date criteria

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Sorted alphabetically

Sorted A->Z

Sorted & no blanks - rng

Sort length

From a cell range

Sorted A-Z from range

Contains string in rng

Begins with criterion

Based on a date range

Based on dates

Year - month from dates

Based on date criteria

Extract filtered table

Extract & sum condition

Two conditions

Sum uniq. dist. rec.

Assign randomly unique

Sums, return unique

Sorted, no blanks - rng

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using critera

Common values 3 lists

Label duplicate records

Dupes - date, wk, month

Dupes from rng contain

Filter dupes begins w.

Min unique number

Dupe vals sorted date

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

Sort column - frequency

Frequency - criteria

Sort rng - frequency

Sort count freq. condi.

Sort two columns

Sort records

Sort table

Sort adj. txt horiz. (1)

Sort unique A-Z blanks

Sort cell delimiter [VBA]

Sort Excel table [VBA]

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 range

Vlookup rng - records

Vlook col - return rng

Search and return multiple values

Strings in any 2 cols

Strings in 2 cols each

Strings in column

Contains string - column

Filter records

Extract using criteria

Extract using criteria(2)

Extract using criteria(3)

Recs betw. this & that

Records betw. 2 dates

Date range & condition

Records in two tables

Unique records

Common records

Duplicate columns

Unique distinct records

Extract unique distinct records from two data sets

Sort based on freq.

Filter unique distinct records using criteria

Count uniq. dist. [2010]

Unique dist. rec. criteria

Records - condition(2)

Records - condition(1)

Filter unique distinct records

Count unique distinct records

Duplicate records

Extract duplicate records

Count records

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 […]

Extract records containing digits [Formula]

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

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

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

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

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 […]