The consolidate option is found in the which group
Answers
Answered by
1
Answer:
Select the upper-left cell of the area where you want the consolidated data to appear. On the Ribbon, Choose Data > Consolidate to view the Consolidate dialog: In the Function box, click the summary function that you want Excel to use to consolidate the data.
Explanation:
Similar questions
Math,
2 months ago
Math,
2 months ago
Economy,
4 months ago
Math,
4 months ago
India Languages,
10 months ago
Physics,
10 months ago
Social Sciences,
10 months ago