Front Cover -- Copyright -- Table of Contents -- About the Author -- Comments from readers -- Acknowledgments -- Dedication -- Introduction -- Chapter 1 - Techniques -- 1-A Dilemma with Relative References -- 2-Build a Formula with a Formula -- 3-Combining a List of Values into One -- 4-Comparing Worksheets -- 5-Creating a Series of the 15th of the Month and the Last Day of the Month -- 6-Match Colors -- 7-Reorganization of Data -- 8-Scrolling Text -- 9-Sequences -- 10-Variable Linked Cell -- Chapter 2 - Pivot Tables -- 11-Pivot Table Anomaly and Workaround -- 12-Reverse Pivot Table -- Chapter 3 - Features -- 13-Conditional Formatting -- 14-Data Validation on Steroids -- 15-The "Justify" Command -- 16-Unusual Text to Columns -- Chapter 4 - Formulas -- 17-Interesting Formula using MATCH and OFFSET -- 18-Using LARGE (or SMALL, etc) on Non-contiguous Ranges -- 19-Using SUMPRODUCT for Filtered or Hidden rows -- 20-VLOOKUP with Multiple Answers -- 21-Reversing a list -- Chapter 5 - Array Formulas -- 22-Alphabetizing without Sorting (an Array-Formula) -- 23-An Odd Combination -- 24-Another Array-Formula Application - Finding the Latest Date from a String with Embedded Dates -- 25-Calendar with One Formula (Array Entered, of Course!) -- 26-Comparing Lists -- 27-Finding the Last Cell Using a Formula -- 28-Getting Sums from a Text String -- 29-Parsing Information Without Breaking in the Middle of a Word (an Array Formula) -- 30-Using an Array Formula to Extract a Part Number -- 31-VLOOKUP with Multiple Answers - Another Look -- Chapter 6 - Charts -- 32-Dynamic Range Names and Charts -- 33-More Dynamic Charting -- 34-Show a Chart Only When the Data is Complete -- Chapter 7 - VBA -- 35-Ensure a Cell Contains a Value Before Saving File -- 36-A VBA User-Defined Function for Getting Sums from a Text String -- 37-Delete Defined Names in One VBA Statement.

38-Ensuring Macros are Enabled -- 39-Getting a List of Sheet Tabs in a "Table of Contents" -- 40-Inserting Totals with VBA -- 41-Limiting Cells a Person Can Select Without Protecting the Worksheet -- 42-Many Buttons, One VBA Procedure -- 43-Multiple Matches -- 44-Overriding Cell Calculations -- 45-Quick Way to Put Sequential Numbers into a Range Using VBA -- 46-Trimming and Cleaning all Cells on a Worksheet -- 47-Using a Demo of a File - Not Allowing it to be Used More than X Times -- 48-Using Excel Ranges With the VBA Join Method -- Chapter 8 - Miscellaneous -- 49-What Really is the Issue with Dates? -- 50-Getting Sums From a Text String, Revisited -- 51-Useful Filtering Technique -- 52-Referencing in Long Worksheets -- 53-Interesting Conditional Formatting -- 54-Highlighting Cells Which are Values Which Should Be Formulas, Without Using VBA -- 55-A Piece of Silliness -- Index -- Back Cover.