+ Reply to Thread
Results 1 to 10 of 10

(Solved) sum maximum consecutive 1 value in a calendar row

Hybrid View

  1. 02-07-2023, 06:28 AM #1
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,183

    Re: sum maximum consecutive 1 value in a calendar row

    with 365, another option:

    =MAX(LEN(TEXTSPLIT(TEXTJOIN("",TRUE,B3:ABC3),0)))
    Reply With QuoteRegister To Reply
  2. 02-07-2023, 08:20 PM #2
    WenPeters
    WenPeters is offline
    Registered User
    Join Date
    02-06-2023
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    4

    Re: sum maximum consecutive 1 value in a calendar row

    Thankyou avk, Caracall and Gregb11 - much appreciated
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Maximum consecutive columns with value equal or above 2
    By Teddy Tash in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-24-2016, 02:09 PM
  2. Consecutive 5 Maximum number in a column
    By ssb648 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2016, 03:12 AM
  3. Counting Maximum Consecutive Days
    By Delleeb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2013, 03:51 PM
  4. Maximum value in consecutive numbers separated by 0
    By so1989 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-08-2012, 10:05 AM
  5. [SOLVED] count the maximum number consecutive
    By Berna11 in forum Excel General
    Replies: 9
    Last Post: 07-13-2012, 11:27 AM
  6. Maximum Consecutive Drawndown formula
    By asaini009 in forum Excel General
    Replies: 6
    Last Post: 02-06-2012, 05:24 PM
  7. Calculating value for maximum consecutive value
    By than_k22 in forum Excel General
    Replies: 7
    Last Post: 10-15-2010, 01:08 PM

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