Formulas and Functions

MS Excel - Formulas and Functions

Add Descriptive Text to Your Formulas Move Relative Formulas Without Changing References Compare Two Excel Ranges Fill All Blank Cells in a List Make Your Formulas Increment by Rows When You Copy Across Columns Convert Dates to Excel Formatted Dates Sum or Counting Cells While Avoiding Error Values Reduce the Impact of Volatile Functions on Recalculation Count Only One Instance of Each Entry in a List Sum Every Second, Third, or nth Row or Cell Find the nth Occurrence of a Value Make the Excel Subtotal Function Dynamic Add Date Extensions Convert Numbers with the Negative Sign on the Right to Excel Numbers Display Negative Time Values Use the VLOOKUP Function Across Multiple Tables Show Total Time as Days, Hours, and Minutes Determine the Number of Specified Days in Any Month Construct Mega-Formulas Mega-Formulas that Reference Other Workbooks Database Functions to Take the Place of Many Functions

Excel's named ranges and cell comments can help clarify formulas, but sometimes you want to put documentation into the formula itself. With the hacks in this section, you can add descriptive text to your formulas quickly and easily.
Even when you have written various formulas and functions yourself, coming back to them at a later date often requires that you follow cell references to try to figure out what the formulas are doing. It would be great if you could simply add to the end of your formula some text that wouldn't interfere with the result, but would give you the information you require at a later stage.

[Next]