how to group records in a new worksheet
 

I have a big datasheet in Excel which includes customer/product/sales
columns. In a new sheet I would like to consolidate all sales per customer
and in another per product. Then I would like to show the top20 customers
resp. top20 products. What is the best way to do this in Excel?
Thanks for your help.
Gunther

how to group records in a new worksheet
 

Hello,

in a other sheet you can use the function "consolidate" (under data). and you
can shoose to consolidate from your worksheets.

hope it's usefull
flo




"Gunther" wrote:

I have a big datasheet in Excel which includes customer/product/sales
columns. In a new sheet I would like to consolidate all sales per customer
and in another per product. Then I would like to show the top20 customers
resp. top20 products. What is the best way to do this in Excel?
Thanks for your help.
Gunther