Dont miss this - Offset function made simple

Formula Tips

A formula to calculate a ratio

Alternatives to nested IF functions

Automatic list numbering

Avoid error displays in formulas

Calculate the day of the year and days remaining

Calculate the number of days in a month

Calculating a conditional average

Change cell values using Paste Special

Change the formatting of your subtotal rows

Compare ranges by using an array formula

Converting non-numbers to actual values

Count AutoFiltered rows

Counting distinct entries in a range

Creating a "megaformula"

Dealing with negative time values

Delete all input cells, but keep the formulas

Displaying AutoFilter criteria

Force a global recalculation

Hiding your formulas

Identify formulas using Conditional Formatting

Locate phantom links in a workbook

Perform math operations without formulas

Perform two-way table lookups

Referencing a sheet indirectly

Round values to the nearest fraction

Rounding to n significant digits

Sum the largest values in a range

Summing times that exceed 24 hours

Text and values in one cell

Transforming data with formulas

Using Data Validation to check for repeated values

Working with pre-1900 dates