Consolidating/Grouping Data
 

Hi all,

I have a large list of data, example shown here;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 87
WB01 01810-11004 392528 27
WB01 01821-00505 392202 32
WB01 01821-00505 392789 84
WB01 01821-00505 392789 60
WB01 01821-00505 392789 85
WB01 01821-00505 392790 80
WB01 01821-00505 392790 44

--------------------


....the list goes on. How can I group this data by M/C, Parts, Batch
and then total up the Qty? So the list would end up as follows;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 114
WB01 01821-00505 392202 32
WB01 01821-00505 392789 229
WB01 01821-00505 392790 124

--------------------


The data above has been group and a total produced....


Any ideas how I can do this? TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=523479

Consolidating/Grouping Data
 

Try DataSubtotals

HTH
--
AP

"gti_jobert" a
écrit dans le message de
...

Hi all,

I have a large list of data, example shown here;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 87
WB01 01810-11004 392528 27
WB01 01821-00505 392202 32
WB01 01821-00505 392789 84
WB01 01821-00505 392789 60
WB01 01821-00505 392789 85
WB01 01821-00505 392790 80
WB01 01821-00505 392790 44

--------------------


...the list goes on. How can I group this data by M/C, Parts, Batch
and then total up the Qty? So the list would end up as follows;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 114
WB01 01821-00505 392202 32
WB01 01821-00505 392789 229
WB01 01821-00505 392790 124

--------------------


The data above has been group and a total produced....


Any ideas how I can do this? TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=523479

Consolidating/Grouping Data
 

You can add subtotals through Menu: Data, Subtotals

Once input you can shrink / expand the data using the + & - signs on the
left of the sheet. (clicking on the 1 or 2 etc at the top of the left side
does this also)

"gti_jobert" wrote:


Hi all,

I have a large list of data, example shown here;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 87
WB01 01810-11004 392528 27
WB01 01821-00505 392202 32
WB01 01821-00505 392789 84
WB01 01821-00505 392789 60
WB01 01821-00505 392789 85
WB01 01821-00505 392790 80
WB01 01821-00505 392790 44

--------------------


....the list goes on. How can I group this data by M/C, Parts, Batch
and then total up the Qty? So the list would end up as follows;


Code:
--------------------

M/C PARTS BATCH QTY
WB01 01810-11004 392528 114
WB01 01821-00505 392202 32
WB01 01821-00505 392789 229
WB01 01821-00505 392790 124

--------------------


The data above has been group and a total produced....


Any ideas how I can do this? TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=523479