» 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:
- Investing for Dummies, Third Edition
- PowerPoint® 2002 For Dummies®
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The 11 Immutable Laws of Internet Branding
- Microsoft Office XP Introductory Concepts and Techniques
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
