SMALL function

Excel » Functions » Statistical » SMALL function »

SMALL function with multiple cell ranges

Today I learned how to sort numbers from multiple cell ranges thanks to Sam Miller. It is surprisingly simple and easy. […]

SMALL function – INDEX MATCH

The array formula in cell C11 gets 3 values in one fetch, the INDEX function allows you to do that […]

How to ignore zeros using the SMALL function

The formula in cell D3 is an array formula, it will extract the k-th smallest value ignoring zeros.

SMALL function – multiple conditions

The array formula in D10 extracts numbers sorted from small to large from column D if Region is equal to […]

SMALL function for text

The array formula in column E, shown in above picture sorts text values from column B. The Length columns prove […]

SMALL function with duplicates

The formulas in column E, shown in the picture above, extracts the k-th smallest value from B3:B9 ignoring the duplicate numbers. […]

INDEX MATCH – multiple results

The array formula in cell E6 extracts values from column C when the corresponding value in column B matches the […]

How to use the SMALL function

The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.

Basic formulas

Count

Cells with text values

Cells with empty values

String in cell

String in cell range

Strings in cell range

String in rng, case sens.

Cells equal list values

Containing any list value

Rows containing data

Pattern in cell value

Workdays betw. 2 dates

Specific wkdays in rng

Sum nums betw. dates

Overlapping ranges

Latest date - condition

Match date in date rng

First word in cell value

K-th word in cell value

Last word in cell value

First three digits in value

Numbers in cell value

Text string manipulation

Replace part of formula

Index match

Critera - multiple results

Get the latest revision

Last value in column

Last value unsorted list

Extract using criteria(3)

Lookup - two conditions

Two-dimensional lookup

Find closest value

Logic

If cell has value

If cell contains any text

Cell contains list value

Cells equal to list value

Cell contains list value

If cell contains text

Multiple conditions

IF & AND - Conditions

Sum based on criteria

Running totals - date

Critera - multiple results

Two-dimensional lookup

Small function

SMALL - multiple rngs

Small - Index Match

SMALL - ignore 0

SMALL with conditions

SMALL function for text

How to use the MIN function

Lookup using two criteria

Based on month

How to quickly find the maximum or minimum value [Formula]

From a cell range

Find closest value

Max function

How to use the MAX function

Fuzzy vlookup [Array formula]

Combine sheets

Extract unique distinct values sorted based on sum of adjacent values

Based on month

How to quickly find the maximum or minimum value [Formula]

Index function

Rearrange cells in a cell range to vertically distributed values

Numbers in cell value

How to remove unwanted characters in a cell

Identify all characters in a cell value

How to remove numbers from a cell value

Critera - multiple results

Find numbers closest to sum

How to use the INDEX function

Year - month from dates

Two-dimensional lookup

From a cell range

Sum function

Containing any list value

Sum by group

Sum nums betw. dates

Running totals

How to use the SUM function

Count overlap. days(1)

Strings in cell range

Count overlapping dates

Sum based on multiple criteria

Sum values between two dates and based on a condition

Sum values containing text based on a condition

String in rng, case sens.

Unique dist. values

String in cell range

Sum cells with check boxes

Sum only visible cells

Formula categories

Count

Dates

Extract

Index and Match