+ Reply to Thread
Results 1 to 3 of 3

count consecutoive wet days in a year

  1. #1
    Registered User
    Join Date
    10-07-2018
    Location
    india
    MS-Off Ver
    2013
    Posts
    3

    Wink count consecutoive wet days in a year

    i want to count max consecutive days when cell value greater or equal to 1..for example:


    day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12 day13 day14 day15 day16

    0 0 0 0 0 0 0 5 5 5 4 3 6 0 0 0
    0 2 1 8 0 7 2 5 4 0 0 0 0 0 0 6
    1 2 3 5 6 8 3 0 8 7 1 3 4 6 7 8

    i want to find longest streak for all rows..not each row separately ..here max consecutive value is 8...which starts from last value of row 2 ending before 0 in 3rd row.....

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,142
    Hello DAVID WEBB,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2010, 2016
    Posts
    6,341

    Re: count consecutoive wet days in a year

    Hi,

    As you may be read description of this sub-forum - this one is solely to introduce yourself.

    So here I'd say: welcome to the forum. And that's it.

    With your merit question, please go to appropriate sub-forum. Look what sub-forums we have: http://www.excelforum.com/microsoft-...el-help-forum/ and post a new thread in one of them (the most appropriate one).
    Best Regards,

    Kaper

+ 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