+ Reply to Thread
Results 1 to 2 of 2

running total for consecutive days MA points either "UP" or "DOWN"

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    6

    running total for consecutive days MA points either "UP" or "DOWN"

    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
    Last edited by micoz; 02-07-2010 at 12:15 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: running total for consecutive days MA points either "UP" or "DOWN"

    in M2 and copy down

    =if(L2=L1,M1+1,1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1