Chapter 6. Hacking Formulas and Functions

     

Hacks #60-80

Section 60.   Add Descriptive Text to Your Formulas

Section 61.   Move Relative Formulas Without Changing References

Section 62.   Compare Two Excel Ranges

Section 63.   Fill All Blank Cells in a List

Section 64.   Make Your Formulas Increment by Rows When You Copy Across Columns

Section 65.   Convert Dates to Excel Formatted Dates

Section 66.   Sum or Counting Cells While Avoiding Error Values

Section 67.   Reduce the Impact of Volatile Functions on Recalculation

Section 68.   Count Only One Instance of Each Entry in a List

Section 69.   Sum Every Second, Third, or nth Row or Cell

Section 70.   Find the nth Occurrence of a Value

Section 71.   Make the Excel Subtotal Function Dynamic

Section 72.   Add Date Extensions

Section 73.   Convert Numbers with the Negative Sign on the Right to Excel Numbers

Section 74.   Display Negative Time Values

Section 75.   Use the VLOOKUP Function Across Multiple Tables

Section 76.   Show Total Time as Days, Hours, and Minutes

Section 77.   Determine the Number of Specified Days in Any Month

Section 78.   Construct Mega-Formulas

Section 79.   Hack Mega-Formulas that Reference Other Workbooks

Section 80.   Hack One of Excel's Database Functions to Take the Place of Many Functions



Excel Hacks
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets
ISBN: 0596528345
EAN: 2147483647
Year: 2003
Pages: 136

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net