View Poll Results: number of consecutive lengths in a month of all year

Voters
1. This poll is closed
  • number of consecutive lengths in a month of all year

    1 100.00%
  • number of consecutive lengths in a month of all year

    0 0%
Results 1 to 13 of 13

number of consecutive lengths in a month of all year

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2016
    Location
    india
    MS-Off Ver
    2016
    Posts
    4

    Question number of consecutive lengths in a month of all year

    hi
    i have daily rainfall data in excel (column A=year, B=month, C=rainfall amount in mm).
    i want to calculate number of times the rainfall value is consecutively zero, that is if the value is zero for consecutively 2 or 3 days they should be considered as one, and and number of consecutive times values are zero to be calculated monthly wise (all the year January month .......)
    please help me i have attached the data file also.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Running Totals from 24 hours to month, month to year without year decreasing
    By Safetyintern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2015, 01:13 PM
  2. [SOLVED] How can convert number to Month and Year?
    By Akatecho in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-16-2014, 09:26 AM
  3. [SOLVED] Formula to return End OF Month date with non-calendar month lengths.
    By Snoddas in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-09-2014, 08:45 AM
  4. Replies: 3
    Last Post: 05-29-2013, 01:57 PM
  5. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  6. Formula for finding number of consecutive blank cells over a year - See info!
    By oldtauntonian in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-16-2013, 08:31 AM
  7. [SOLVED] Convert Number into Month and Year
    By acsishere in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2013, 04:43 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