Learn Excel Episode 974: NonContiguous Spearing

Posted in Companies, Podcasts on March 20, 2009

You may have seen how to create a spearing or 3-D formula such as =SUM(Jan:Dec!B3). In Episode 974, an amazing way to create a 3D reference to non-contiguous sheets.

Watch Video Watch Video on External Site

Tags: Microsoft, 3D, Excel, MrExcel