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