need help regarding Excel

[Tanu]

Hi, I have huge datbase containing yearwise, countrywise, product and sub product wise sales unit volume data. I need to generate a report in excel which produce the following outcomes,

What are my top ten countries for each category of products?

What are my top unit volume movers and where? How to flag them??


Can anyone help me?

 

[jhargram]

Hi Tanu Can you please update the datasheet for this.

 

[srinidhi]

The best way is to generate a pivot table with country & products, Paste special to an empty cell & apply conditional formatting which will highlight the top achievers.

 

[vijaySharma]

Tanu,


You can try out as explained by Srinidhi


Or


You can convert your data into a Data Table...

and apply your filters whereever applicable


HTH

~VijaySharma

 

[Tanu]

Hi, Thank u very much for the reply. I have already arranged the data in pivot table and applied conditional formatting too. My manager does not seems to be happy with pivot table Is there any other efficient way?? I want to flag the growth rate like +30%, -30%

 

[Hui]

You can setup any combination of a Table with appropriate headings and row titles, but you will need to extract the data manually using Sumproduct, Index(Match()) or Sum(Offset()) functions depending on how your data is setup

 

[Tanu]

Can anyone provide me sample spreadsheet regarding the same?

 

[Hui]

Have a read of:

http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

or

http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/


Alternatively can you please post your data somewhere and include a list of requirements