Need very simple formula to show dynamic cumulative results

[blazy]

Hello Excel gurus,

I need help with one simple thing:

I just want to show the commulative data from januar - selected month for 2013 and 2014, for selected dealer.

See the attached file, I want to show the results in tab "dashboard", data is in other two sheets. I think you will figure it out easily.

Thanks!

 

[Nebu]

Hi:

Please find the attached.

 

[blazy]

Thanks, working great!

 

[blazy]

Hello,

I need very simple formula, could you please see the attached file?
I need to return name for top 3 rank postition for choosen motnh. Ranking is in second sheet.

Thanks!

 

[blazy]

any ideas?

 

[Nebu]

Where you want to return the rank can you be little more specific...

 

[Smallman]

Hi Blazy

I changed Row 34 from text to numbers. This helped with formula. As you have a table dedicated to each month's rank I used an index and match formula.

See attached file.

Take care

Smallman

 

[blazy]

Thanks!! I will try to do it for the rest on my own, I will use your procedure!

Thanks again!

 

[blazy]

Hey, could you take a look for one last thing please... this offset function is my nemessis...

I need dynamic sum.

see the attached file.

Thanks!

 

[Nebu]

Hi:

Please find the attached..

 

[blazy]

Thank you!!!