Creating a worksheet with stats created from selected data...

A

Amanda

I am creating a spreadsheet that I believe requires 3 sheets. The first sheet will be a database containing up to 500 company names. The second sheet will contain a pivot table for total stats, so far so good. I also need to produce different stats (percentages of actual vs target) for a selected number of companies (the companies will remain the same or only change infrequently). Any suggestions for the best way forward for the third sheet? TIA.
 
Top