Consolidate and Sum the Rows

Johnzea

New Member
Joined
Apr 5, 2019
Messages
23
I have tried the basic 'Data' then select 'Consolidate' then 'Sum' etc.....looking for some help to sum up the QTY and SYM and get rid of the dups...I have attached (2) images...the 'Before' and what I'm looking to accomplish with the 'After'...any help with this would be very much appreciated..

Johnzea
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,444
You attached nothing

try to post a link to shared excel file with representative example and expected result. use GoogleDrive, OneDrive or any similar.
 

Johnzea

New Member
Joined
Apr 5, 2019
Messages
23
When I right click on the image icons in the body of the thread and select view image i can see the images...Ok I will use GoogleDrive with a new thread..
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,444
this is your whole post so re-read post#2



attachments from your local computer will not work
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,787
Messages
5,470,772
Members
406,720
Latest member
tylergaps

This Week's Hot Topics

Top