Posts by shanethompson

  • Add a trend arrow to dashboard

    I have 12 months of data - cells E7 to P7, in cell Q7 I want to place an arrow (Up, Down Sideways) based on the trend for the previous 12 months



    Looking for the calculation and how to format it, to achieve the result


    Thanks

  • Calculation required - I think

    [INDENT]
    [COLOR=blue !important][COLOR=blue !important]Hi [COLOR=blue !important]All[/COLOR][/COLOR][/COLOR]
    I have a spread sheet that is looking at performance by month
    What I would like to do is have a calculation in one cell that looks at the tend to see if the measure is improving or not


    How my sheet is set up


    In row 8 from Column "E" to "Q" I have the names of months Aug 2015 to Aug 2016
    In row 9 under each of the months I enter a performance figure


    In Row 9 Column "S" I want a calculation that looks at the data entered so far and works out a trend placing an arrow for 3 different scenarios Performance Improving = Arrow pointing up, Or Performance staying the same = Arrow sideways or Performance declining arrow pointing down (I would use the starting data as per the cell E8)
    with this calculation I need it to realise if there is blank data then it doesn't count this as Zero


    Can someone please help


    Thanks [/INDENT]