Consolidating/Grouping Data

[gti_jobert]

Hi all,

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

Please Login or Register  to view this content.

....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;

Please Login or Register  to view this content.

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


Any ideas how I can do this? TIA

[Ardus Petus]

Try Data>Subtotals

HTH
--
AP

"gti_jobert" <[email protected]> a
écrit dans le message de
news:[email protected]...
>
> 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
>

[Lisa]

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
>
>