How Do I Consolidate Positions in Excel?

James H. Sterling
James H. Sterling
• • 7 min read

Understand everything surrounding How Do I Consolidate Positions in Excel with our in-depth report.

How Do I Consolidate Positions in Excel?

What should you know about How Do I Consolidate Positions in Excel? Get the answers in this feature article.

Combine duplicate rows and sum the values with Consolidate function

Must Read

  1. Click a cell where you want to locate the result in your current worksheet.
  2. Go to click Data > Consolidate, see screenshot:
  3. In the Consolidate dialog box:
  4. After finishing the settings, click OK, and the duplicates are combined and summed.
James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist
Twitter Linkedin

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.

Share this article
Twitter Facebook Pinterest