hi all!

i am having a database of sales turnover for differenct products of
different companies for a period as under:

COL"A" - MONTH & YR
COL"B" - COMPANY NAME
COL"C" - PRODUCT NAME
COL"D" - UNITS SOLD
COL"E" - VALUE SOLD

JAN05 - X - XX - 10 - 1000
JAN05 - X - XXX - 5 - 400
FEB05 - Y - YY - 20 - 500
MAR05 - X - XX - 5 - 500
MAR05 - Y - YYY - 10 - 600
MAR05 - X - XXX - 20 - 2000
|
v

|
v

what i want is to extract the periodwise, companywise, productwise
totals of units sold (COL"D") & value sold (COL"E") and export it to
another worksheet under the same column headings so that i can create a
pivot table for further analysis!

is there any easy way to achive this thru xl formula or by any other
method?

expecting help!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=507355