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