Results 1 to 6 of 6

formula to find maximum consecutive positive values by year

Threaded View

  1. 11-07-2022, 10:37 PM #1
    idealist87
    idealist87 is offline
    Registered User
    Join Date
    09-28-2022
    Location
    Perth
    MS-Off Ver
    O365
    Posts
    29

    formula to find maximum consecutive positive values by year

    HI

    I got data by year and return in column C and D

    Googled it and found the maximum consecutive positive and negative value for entire Column C. But now I need to find it by year after year.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find and sum of the most consecutive positive numbers in a column A
    By rayhen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2021, 09:36 AM
  2. [SOLVED] How to find the maximum value of the last 6 consecutive days without spaces?
    By rayhen in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-22-2020, 11:09 PM
  3. Count unique values with criteria and blanks and an average of maximum consecutive values
    By mrsak87 in forum Excel General
    Replies: 2
    Last Post: 07-30-2018, 02:21 PM
  4. [SOLVED] Maximum cumulative value for the consecutive 3 days of data in 1 year period
    By bennyistanto in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2017, 08:43 AM
  5. Find maximum output of a formula as long as another variable is positive
    By stellan76 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2016, 03:50 PM
  6. [SOLVED] Find consecutive 15 positive or negative numbers in a column
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 05:26 AM
  7. Need to Find the Maximum Sum of Four Consecutive Rows in an Array
    By smotown in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 03:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1