COLUMN function

Excel » Functions » Lookup and reference » COLUMN function »

Rearrange cells in a cell range to vertically distributed values

The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]

How to use the COLUMN function

The COLUMN function returns the column number of the top left cell of a cell reference. If the argument is not […]

Search for a text string in a data set and return matching records

Question: How do I find rows that contain a specific string value in a data set? Answer: Array formula in […]

Remove blank cells

In this blog post I will provide two solutions on how to remove blank cells and a solution on how […]

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