Ranking Per Store Per Month Sales.

[ysahme]

Good Day! I'm consolidating a sales per year..

My boss want to see there Ranking per Store and by Month..

From FO01 , FO02 ..... to FO99..

From January to December..

If possible even in per Item..

Thank you in advance...

 

[Faseeh]

Hi ysahme,


Welcome to the Forums, Please elaborate your problem a little further and upload a sample file!


Faseeh

 

[ysahme]

Store Month Meat type Amount Supervisor

FO01 January Pork 10,000 William

FO02 January Pork 20,000 Dan Jervy

FO03 January Pork 15,000 Lemuel

FO01 February Pork 15,000 William

FO02 February Pork 15,000 Dan Jervy

FO03 February Pork 10,000 Lemuel

And so on..

They want to see the ranking per month...

In pivot table i use rank function but i filter it per month...

 

[bobhc]

Good day ysahme


There is a file in my Dropbox that may help you


https://dl.dropbox.com/u/34893656/ysahme.xlsx

 

[ysahme]

bobhc thanks for the help but it still don't answer my problem...

it's the same idea that i did...

you just filter it then us rank formula...

 

[bobhc]

Good day ysahme


But the link I put in the spread sheet shows you how to do this!

 

[ysahme]

Thanks bobhc....

you are indeed excel ninja..