Excel Forum

Combine Duplicates and Sum the result

Colin Cowan

New Member

Members

Forum Posts: 2

Member Since:
October 27, 2022

Offline

November 7, 2022 - 11:13 am

Need some help see attched example of "result of a powery query" and "desired outcome of the query" being the next step

Colin

Philip Treacy

Admin

Forum Posts: 1512

Member Since:
October 5, 2010

Offline

November 7, 2022 - 12:41 pm

Hi Colin,

When you have a duplicate in the Selection column, how do you decide which to keep? I can't see any logic to how this is chosen. If you look at the Break Up column, how are the results here decided?

Regards

Phil

Colin Cowan

New Member

Members

Forum Posts: 2

Member Since:
October 27, 2022

Offline

November 7, 2022 - 3:36 pm

Phil

All good I finally worked it by using the group by function

Colin

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Andy Kirby

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

wahab tunde

Cong Le Duc

Faisal Bashir

Ivica Cvetkovski

Blaine Cox

Shankar Srinivasan

riyepa fdgf

Hannah Cave

Len Matthews

Kristine Arthy

Forum Stats:

Groups: 3

Forums: 24

Topics: 6205

Posts: 27210

Member Stats:

Guest Posters: 49

Members: 31878

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen