I am trying to include a colomn in my worksheet that keeps a running total of how many consecutive days a column L:L returns the value either "UP" or "DOWN".
So it would look something like this:
"Direction" -"Days in Trend"
UP - 1
UP - 2
UP - 3
DOWN - 1
DOWN - 2
DOWN - 3
DOWN - 4
UP - 1
DOWN - 1
DOWN - 2 ETC.
-
So from that, i will know, the Trend was "UP" for 3 days, "DOWN" for 4 days, "UP" for 1 day, then "DOWN" for 2 days.
I could then include the "days in Trend" column in further calculations
Any help will be much appreciated.
Thanks
Bookmarks