We are looking for the amount of scrap compared to good units - but as a percentage of production and not simply a numberical value. Using a Pivot Table in Microsoft Excel in Episode #1528, Bill produces his first solution to the query.
...This episode is the video podcast companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen and the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.