Results 1 to 3 of 3

Please Correction My Consecutive Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Tehran, Iran
    MS-Off Ver
    2019 v2306
    Posts
    145

    Please Correction My Consecutive Formula

    Hello
    I have a formula for calculate Max Consecutive "Win" in the Column A:A

    {=MAX(FREQUENCY(IF(A:A="Win",ROW(A:A)),IF(A:A="Loss",ROW(A:A))))}

    Formula is Correct, but I need ignore Hided Rows :
    A2 = Win
    A3 = Win
    A4 = Win
    A5 = Loss
    A6 = Win
    A7 = Win --> Hided
    A8 = Win --> Hided
    A9 = Win
    A10 = Loss

    Max Consecutive "Win" = 4
    but I Hided A7 and A8 then in this situation Max Consecutive "Win" =3

    Please look at my attach file


    Thank you in advance for your answer
    Attached Files Attached Files
    Last edited by soubasa; 04-12-2023 at 05:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula finds the max number of consecutive times and the Total of consecutive values
    By rayhen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2021, 03:06 AM
  2. Looking for formula correction
    By wonderd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2019, 02:23 PM
  3. correction of formula please............
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM

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