need vba code to group set of data by column A:A and sum and average of lenght of column

manilara

New Member
Joined
Feb 3, 2013
Messages
11
Dear sir

I want to group by Column A (i.e. Item) and Column N (i.e. length) and also want to add the sum total of each change in lengths of column E,F,G,H,I,J In the column K subtotal of E:J lenghts of column & want to add the average of L,M,N

Pls find the attachment what i looking for


 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
'dear sir' - what about the female programmers?

can you post an image of what you have and what you want somewhere and provide the links to the images here?
 

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
post your image on some picture sharing site (google plus, whatever). The copy the link of that image and on this website click on the 'insert image' button above the reply box. Then paste the link. That's it.
 

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
why don't you do this with a pivot table? That is exactly what they are for.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,950
Messages
5,599,028
Members
414,275
Latest member
Pungie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top