• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Dynamic year to date calculation

    Hi Faseeh, Our financial year is from Oct - Sep. The year to date calculation (for the whole year) is thus sum(Oct:Sep). If it is only Feb, then the calculation will be sum(Oct:Feb). The formula in the yellow block F21 would thus be =SUM(Data!G122:G126) and in G21 it would be...
  2. G

    Dynamic year to date calculation

    Hi, I have uploaded a file to https://hotfile.com/dl/149698705/68f5964/Market_Shares.xlsm.html I hope that this helps.
  3. G

    Dynamic year to date calculation

    Hi Luke, The slider controls monthly data. As you slide, the graphs scroll across displaying 13 months. There is a table which showns the CurrentMonth compared to last year as well as financial year (Oct to CurrentMonth). This is where I have a problem because the OffSET formula (which...
  4. G

    Dynamic year to date calculation

    Hi, I have a list of monthly data that spans about 11 years. I have created a slider that controls graphs on a dashboard that show rolling 13 months (this is the easy part). I now need to show a table that compares the last month on the (eg Feb 2012) with the same month last year (this is...
Back
Top