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