subtotals

[gary]

My worksheet contains 57,000 rows of data in the following
format:

Part Nbr Item Nbr Price
687223007-5 019-038 257.82
687223007-5 68-1366 20.24
687223007-5 68-1378 2.34
687223007-5 68-2232 223.68
687223007-5 68-4115 242.40
687223007-5 019-038 131.07
687223007-5 68-1366 10.12
687223007-5 68-1378 1.17
687223007-5 58-1856 4.24
687223007-5 68-2232 109.23
687223007-5 68-4115 110.80
687233016-4 019-003 76.24
687233016-4 68-2232 22.58
687233016-4 019-003 78.24
687233016-4 68-2232 27.72
687233016-4 019-003 80.78
687233016-4 68-2232 28.76
687252002-0 019-003 465.10
687252002-0 68-1366 31.38
687252002-0 68-1378 3.64
687252002-0 68-2232 134.82
687252002-0 68-4115 129.12
687252002-0 019-003 480.18
687252002-0 68-1366 31.38
687252002-0 68-1378 3.64
687252002-0 68-1856 8.48
687252002-0 68-2232 139.80
687252002-0 68-4115 129.96

When the "Part Nbr" changes, I need the amount-subtotals
for each "Item Nbr".

How can I do this?

Gary

 

[Frank Kabel]

Hi
you may have a look at pivot tables. They will create a report quite
similar to what you want. Have a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
for some information to get started with pivot tables

 

[gary]

Frank,

Your response contained only:

-----Original Message-----
Message unavailable

Gary

 

[Frank Kabel]

Hi
the CDO Web interface makes problems today. See if you can read this
repost:
----
Hi
you may have a look at pivot tables. They will create a report quite
similar to what you want. Have a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
for some information to get started with pivot tables