Page 2 of 2 FirstFirst 1 2
Results 11 to 14 of 14

Thread: 3 consecutive

  1. #11
    Seeker chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    6
    Articles
    0
    Excel Version
    2016


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Didn't work. line 4 should be true based off the 3 consecutive zeros after the d9 not before. line 5 should be true based since there are 3 consecutive zeros after c5.
    need it to be true only after 3 or more zeros after the first number greater then zero, in the row.
    Attached Files Attached Files

  2. #12
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    877
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by chrisl614 View Post
    Didn't work. line 4 should be true based off the 3 consecutive zeros after the d9 not before.
    Look at a new solution.
    If this does not help, I give up.
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #13
    Seeker chrisl614's Avatar
    Join Date
    Apr 2019
    Posts
    6
    Articles
    0
    Excel Version
    2016
    Thanks! But the formula is still not able to accomplish what I was looking for. It seems like the closest itís been is with this formula:

    {=IF(MAX(FREQUENCY(IF(A2:J2=0,COLUMN(A2:J2)),IF(A2:J2<>0,COLUMN(A2:J2))))>=3,TRUE,FALSE)}

    The only problem with this formula is that it doesnít start looking for zero after the first number higher then zero.


    Sent from my iPhone using Tapatalk

  4. #14
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    877
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by chrisl614 View Post
    Thanks! But the formula is still not able ...
    Okay, here's another attempt. This is ARRAY Formula
    Code:
    =OR(IFERROR(IF(COUNTIF(INDIRECT(CHAR(64+LOOKUP(2;1/(A1:J1>0);COLUMN(A1:J1)))&ROW(A1)&":J"&ROW(A1);TRUE);"=0")>0;TRUE;FALSE);FALSE);IFERROR(IF(COUNTIF(INDIRECT(CHAR(64+LARGE(IF(A1:J1>0;COLUMN(A1:J1));2))&ROW(A1)&":J"&ROW(A1);TRUE);"=0")>=3;TRUE;FALSE);FALSE))
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •