software

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

Hello,

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

hope it's usefull
flo

quot;Guntherquot; wrote:

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