Learn Excel Episode 723: PivotText

Posted in Companies, Podcasts on July 14, 2008



After summarizing data in a pivot table, you want to replace the numbers with a simple Yes/No text. Yes if they met the condition, No if they did not.Episode 723 will show the rather convoluted process. In the process of creating the pivot table, you will see data grouping, calculated fields, table options, and then a bizarre conditional number format.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table, Grouping