Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...
These files demonstrate the technique described in the article Office Q&A: After-the-fact captions and easy counts using a PivotTable. Be your company's Microsoft insider by reading these Windows and ...