How To Use Excel Consolidate

Click the button next to the reference entry box to begin selecting your first data set this is the data you wish to merge.

How to use excel consolidate. On the data ribbons select data tools and then consolidate. Microsoft excel 2010 and 2013. Combine duplicate rows and sum the values with consolidate function. Now go to data consolidate. In the consolidate dialog you can.

Click and drag to highlight the data you want to consolidate. This is the window we need to do the magic. The next step is to click into cell c4 which is where we want the consolidate tool to insert our data. In the reference box click the collapse dialog button edit reference icon and select the branch a worksheet. Once you have selected the consolidate option you will see the below window.

Select the sheet or file with data you want to consolidate. The screenshots below will help you see an example of how to use the excel consolidate function. The consolidate tool in excel is located in the data menu and combines values from multiple ranges into one new range. The consolidate is a useful tool for us to consolidate multiple worksheets or rows in excel so with this function we can also summarize multiple rows based on the duplicates. Click a cell where you want to locate the result in your.

You would use this feature when you have a single text column on the left and the column has many duplicate values. Choose a function type which determines the consolidation method add references to be consolidated. And create links to the source data if it is located in an external target. We then click on consolidate. Use the drop down menu below function to select a method of consolidation.

To consolidate branch a income statement data. You can also type the reference to the cell range in yourself if you d prefer. Click on the consolidate icon under the data tools section to open the consolidate dialog. Select the consolidation worksheet. Ensure the data is organized in the same way see example below.