+ Reply to Thread
Results 1 to 5 of 5

Count sequence of data below a determined value

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2010
    Posts
    22

    Count sequence of data below a determined value

    Hi!

    I want to know what formula can I use to identify the number of consecutive times that a value below 1 happens in a sequence. Because these are a sequence of values per day, I want it to count starting on the last day available and only if this last day is below 1.
    In the example in the attached picture the formula result should be 4.

    Thanks.

    excel.jpg

  2. #2
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: Count sequence of data below a determined value

    Hi Bruno

    I am not quite following, but I'm interested. Is the format you posted in your picuture how the data is? Where is this formula going to go? What is the last day compaired to?

    Thanks

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Count sequence of data below a determined value

    Quote Originally Posted by nemo74 View Post
    Hi Bruno

    I am not quite following, but I'm interested. Is the format you posted in your picuture how the data is? Where is this formula going to go? What is the last day compaired to?

    Thanks
    Hi,

    Yes, the data is equal to the picture. The formula should be right after the last number. The last day will compare to the previous one to check for a number below 1 and count how many consecutive cells have numbers below one.

  4. #4
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: Count sequence of data below a determined value

    Hi Bruno,
    I have tried and tried. I think this request is beyond my capability. I do not know how to get the dates into the equations.

    I hope someone else can step up and show us both the correct formula for this.

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Count sequence of data below a determined value

    Quote Originally Posted by nemo74 View Post
    Hi Bruno,
    I have tried and tried. I think this request is beyond my capability. I do not know how to get the dates into the equations.

    I hope someone else can step up and show us both the correct formula for this.
    Hi nemo74,
    I appreciate your effort. And I do really hope someone can help us. Thanks for trying!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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