Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Monday, June 30, 2008

Episode 791 - Trimming Total

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.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!