Consolidating data excel

02 Jun

The reference is updated with the selected cells in the Reference field of the Consolidate Data dialog box.

Note that you can click the “Collapse / Expand” button on the right side of the Reference field to collapse the dialog box so you can easily access the spreadsheet.

A script to reformat the data may well be more efficient, but 20k rows is no longer a real limit in a modern Excel workbook. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Wens je later de totalen terug te zien, dan herhaal je bovenstaande stappen en schakelt het vinkje in ‘Eindtotalen voor rijen’ en ‘Eindtotalen voor kolommen’ weer aan.

Randall Blackburn has worked for several Fortune 1000 companies as a technical writer over the past seven years.

He has produced a wide variety of technical documentation, including detailed programming specifications and research papers.

The spreadsheet can be in the same workbook or in a different workbook file.

Ideally, you should keep the consolidation process simple by opening all spreadsheets to be merged in the same workbook. Click the “Function” drop-down box, and then click “Sum” if you just want to replicate the original data in the master sheet.