|
» Using Different Functions to Consolidate Lists
CATEGORY: Excel Consolidating |
VERSIONS: All Microsoft Excel Versions |
|
To consolidate Lists using different functions: 1. Define Names for two Lists, and note the instructions on how to consolidate Lists. 2. Select a cell in any other sheet in the workbook, and from the Data menu, select Consolidate. 3. In Function, choose Sum. 4. In the Reference box, press F3. 5. In the Paste Name dialog box, select List1, click OK, and then click Add to add List1 to All references. 6. Repeat steps 4 and 5 and add List2 and List3 to All references. 7. In Use Labels in, select the Top row and Left column checkboxes, and then click OK. 8. Select a cell under the consolidated Lists, and repeat these steps twice, once with the Count function and then again with the Average function. |
| Screenshot // Using Different Functions to Consolidate Lists |
  |
|
RATING:
3.00
VIEWS: 12373 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Definitive Guide to Excel VBA
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Special Edition Using Microsoft Outlook 2002
- The Basics of Finance: Financial Tools for Non Financial Managers
- Finance and Accounting for Nonfinancial Managers
- Word 2002: The Complete Reference
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
