Hi all,

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


Code
-------------------

M/C PARTS BATCH QT
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, Batc
and then total up the Qty? So the list would end up as follows;



Code
-------------------

M/C PARTS BATCH QT
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? TI

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=52348