Select a cell value from a range based on criteria...

Creating a formula to copy cells depending on adjacent cells...

Combining data from columns with a conditon...

Sort a list by groups of varying number of rows...

Trying to select a distinct set of values but exclude some...

Structured References: Absolute and Relative addressing...

Get result for one column if data associated with that column is equal to two other columns...

Comparing computed dates with entered dates...

Merge columns from different sheets into specific order...

Creating a VLOOKUP that references another sheet, but the sheet name is the content of a cell...

Data fill in specific pattern...

OFFSET formula produces error when attempting dynamic sheet/cell reference...

Combine OFFSET with VLOOKUP...

Formula to get a specific value in string between periods...

Format cell to make calculation with it...

Find and sum multiple values...

Automatically append given text to the result from a formula...

Splitting text columns...

Mark items based on criteria...

How to SUM the number of duplicates in a range by given value?...

How to sum up the total based on occurrences in one column...

Compute PERCENTILE in MS Excel when some values are error values...

VLOOKUP with criterion in range...

Allocate total to "accounts" based on percentage...

Format if table value does not match first row...

Function using IF and AND and OR on a range of cells...

Append string between each cell value in a series...

Discontinuity in results from Excel's Present Value function PV...

Maintaining hyperlinks after adding data, or sorting a list...

Grouping rows by area codes...