Find numbers in sum

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

Find positive and negative amounts that net to zero [UDF]

This article describes a UDF that finds positive and negative numbers that net to approximately zero. You specify the range […]

Find numbers in sum [UDF]

This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]

Identify numbers in sum using Excel solver

Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]

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