×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Combine duplicate rows and sum the values

Combine duplicate rows and sum the values

Combine duplicate rows and sum the values

(OP)
Hi

I have a spreadsheet (Excel 2016) with various columns. I want to Combine duplicate rows and sum the values of the last 2 columns, not all the columns.

Is this possible and if so how. I have used the Consolidate function, but it adds up all of the columns where it can and not just the last columns.

Does anyone know of a way to do this please.

Thanks in advance

RE: Combine duplicate rows and sum the values

Hi,

How about a good example or upload your workbook.

But it sounds like a PivotTable might do the job from what you said.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Combine duplicate rows and sum the values

(OP)
Hi

No problem heres is an example sheet. The highlighted codes are the duplicates.

I only want to see on row with the columns I and J sum for each duplicate row, the other columns c to G not summed but left with the figures left as they are (but only showing once)

I tried a PivotTable but could not get rid of duplicates

RE: Combine duplicate rows and sum the values

In the Pivot Table Fields window, ALL the fields go into the ROWS area except for the last two m3 fields that go into the VALUES area as Sum of...

I get 29 rows of data in my PT.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Combine duplicate rows and sum the values

(OP)
Thanks, I tried the Pivot but got different results to yourself, may well have been the empty rows.

I will take a look, but the result I am sure is correct. Thanks for the help

RE: Combine duplicate rows and sum the values

It WAS the empty row(s) cuz that’s what bit me, too!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close