» Using Different Functions to Consolidate Lists in excel 2007
CATEGORY - Excel Consolidating
VERSION - Microsoft Excel 2007
To consolidate Lists using different functions: 1. Follow instructions in to Consolidate Lists in tip Consolidating Lists in Excel 2007 and select cell A8.
2. Select Data -> Consolidate (in Data Tools Group).
3. In Function, select Count and click OK.
4. Select cell A15.
5. Select Data -> Consolidate (in Data Tools Group).
6. In Function, select Average and click OK.
Book Store:
Recommended Books:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Windows XP Annoyances
- Dictionary of Finance and Investment Terms
- Guide to Financial Reporting and Analysis
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
No comments have been submitted.
