Consolidating excel entries
To use formulas to consolidate the list of responses, first place the unique responses into a range, as shown in C2: C4 in the table at left. In cell D2, enter this formula: Copy cell D2, select D3: D4, and paste to complete the consolidated table.To create a bar, column, or pie chart, select this range or any single cell in the range, and run the chart wizard.Insert a header, "Responses", at the top of the column of data.Select the range and create a pivot table (Data menu).The consolidation process has the following steps: Company A acquired 100% of Company B by paying million.
Their sole benefit is that they show each category's proportion of the total of all categories. While proportions are shown graphically in a pie chart, except for proportions of 25% or 50%, it is not easy to visually determine what these proportions are, unless data labels are used to show the percentages.
In the sheet shown below left, the pivot table is located in cell C1 of the worksheet containing the data.
Drop the Responses field label into the Rows area of the pivot table, and drop another copy of it into the Data area. The pivot table will produce a pivot chart if you use it directly as the source data.
You can use an unlimited number of ampersands to add an unlimited number of cells. Include spaces between cells by adding &" " to the forumla. Copy and paste your formula to reproduce the results in other rows.
Anything within the quotes will be rendered so it could be a space, a comma or any text you want. The official Geeks Geek, as his weekly column is titled, Avram Piltch has guided the editorial and production of since 2007.