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


 

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,560
'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,560
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,560
why don't you do this with a pivot table? That is exactly what they are for.
 

Forum statistics

Threads
1,086,235
Messages
5,388,623
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top