Learn Excel Episode 791: Trimming Total

Posted in Companies, Podcasts on July 17, 2008

After adding Subtotals, Excel will append the word " Total" to the field being subtotaled. In Episode 791, we take a look at how to use a formula to remove the totals so that the data can be used as a lookup table.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas