Hi All
I have attached example
What I'm looking to achieve is in Cell C5 I want to see a Green arrow pointing up if the trend for the last 12 months is showing improvement, Yellow sideways for Static performance and Red down arrow is performance is getting worse
Is there a way to achieve this by only using a formula, as I don't wish to use VBA or Macro's
If needed I can added additional data to the sheet
Thanks In advanceTrend Test.JPG
Bookmarks