PivotTable Text - Episode 1193
Robert asks about using a pivot table to report on text values. This would be easy if Microsoft offered a way to specify "First" as the calculation, but they don't. Instead, episode 1193 shows a Pivot/VLOOKUP solution to the problem.
...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!
Labels: accounting, business, Excel, MrExcel, Pivot Table, spreadsheets, technology, tutorial




