Results 1 to 18 of 18

Need a Formula Tracks the Number of Times a Value Appears

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Need a Formula Tracks the Number of Times a Value Appears

    Hello,
    I need help creating formula that looks back at previous values and totals up the number of times certain values appear.

    BREAKDOWN
    The columns used are A, B, and C

    Column A: contains X’s (which indicate the start of a new day) and 120 (which indicate the start of a new 120 minute period every 8 cells).

    Column B: contains predetermined values either (Neutral, A Up, C Up, A Down, or C Down)
    The formula needs to track every time the all times Non-Neutral values appear.

    Column C: is where the formula would reside.

    RULES FOR FORMULA
    1. If the value in column B equals Neutral then the value in column C equals Neutral. No matter what took place previously.

    2. If all previous "120" cells are Neutral and the current cells value is anything other than Neutral the result is the current value and 1.1

    3. If a succession of values that are all the same and are not "NOT" Neutral then each 120 point will increase its number value by point one (.1).

    4. If a Neutral value separates any Non-Neutral value then each 120 point will increase its number value by one (1).

    Please see spreadsheet for a better understanding.

    Any and all help you could provide for any of the formulas would be greatly appreciated. Thank you.
    Attached Files Attached Files
    Last edited by artiststevens; 11-25-2014 at 03:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Rank the number of times a word appears in a column dynamic with Sorting
    By caliskier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2014, 04:26 PM
  2. [SOLVED] Count the number of times an A appears 5 or more times consecutively
    By CCook310 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-02-2013, 04:02 PM
  3. Replies: 1
    Last Post: 07-18-2013, 10:11 AM
  4. Replies: 8
    Last Post: 07-05-2012, 03:07 PM
  5. Replies: 2
    Last Post: 11-06-2011, 11:01 PM

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