Case sensitive

Excel » Case sensitive »

INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

Filter unique distinct and duplicate values from a large data set

In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]

Case sensitive lookup and return multiple values

The array formula in cell F5 returns adjacent values from column C where values in column B matches the search […]

Count unique distinct values

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

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