|
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
|