Rod sends in today's question. How can his pivot table indicate if ALL of the records for a certain level are marked as complete? Episode 989 will show you a use for the PRODUCT calculation in a pivot table. Also - the arcane custom number format to display positive, negative, zero values in different manners.
This video is the 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!
