Hi,

You may want to create a pivot table. Drag column E to the row area, column
B to the row area again and column C to the data area. Post back and let us
know how it worked

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"tb" wrote in message
...
I routinely download some sales order data from our ERP system into an
Excel spreadsheet:
* Column A has the shipping method of the goods (always either "AIR" or
"OCEAN").
* Column B has part numbers (there could be many instances of the same
part number in this column).
* Column C has the quantity shipped.

What I am after is a formula that will summarize such data:
* Column E would list each individual part number in alphanumerical order.
(No duplicate part numbers allowed!)
* Column F would have the grand total of all the quantities shipped by AIR
for each part number in Col. E..
* Column G would have the grand total of all the quantities shipped by
OCEAN for each part number in Col. E.

Data downloaded into Cols. A, B, C is quite large, so I would need a
fairly optimized formula for Cols. E, F, G. Also, it might be possible to
do what I want with a macro, but I really would prefer a standard Excel
formula due to my limited experience with macros and the fact that the
company I work for severely limits the usage of macros for fear of
viruses...

Thanks.
--
tb