I decided that for my 40th issue of ESL, I would share 5 of my own posts that are very powerful techniques but have been underviewed IMO.
#Excel: Generating a Random Sampling From a List Using VBA and the TEXTJOIN Function by David Hager
#Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager
#Excel: Using Advanced Filter with a Custom List By David Hager
#Excel VBA: Create a Table of File Locations and URLs for Your Favorites by David Hager
#Excel Shift Calendar by David Hager