Tip Printed from ExcelTip.com

---

Using Different Functions to Consolidate Lists in 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.