STREAK

Xlambda · Sep 27, 2022

STREAK Largest consecutive distribution of a given value, byrow or bycol
This is my take on a cool function: STREAK
Added new functionality, max argument [x]
Main calculation core of the function: IF(i, v + i, 0)

Excel Formula:

=LAMBDA(a, v, [o], [x],
    LET(
        b, IF(a = v, 1, 0),
        s, LAMBDA(x, MAX(SCAN(0, x, LAMBDA(v, i, IF(i, v + i, 0))))),
        i, IF(o, BYROW(b, LAMBDA(x, s(x))), BYCOL(b, LAMBDA(x, s(x)))),
        IF(x, MAX(i), i)
    )
)

Book1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

1

2

=CHAR(RANDARRAY(20,20,65,67,1))

=STREAK(B3#,"a")

3

C

B

A

B

A

B

C

B

C

B

C

A

B

C

A

B

C

B

A

1

4

A

B

A

B

C

B

C

A

B

A

B

A

C

B

A

3

5

A

C

B

C

B

A

B

C

B

A

B

C

B

C

1

6

B

A

B

C

A

B

A

B

C

A

B

A

C

A

B

A

3

7

A

C

A

C

B

A

B

C

B

A

B

C

B

3

8

C

A

C

A

B

A

C

B

C

A

B

C

B

1

9

C

A

C

B

A

B

C

A

B

A

C

4

10

B

A

C

B

A

C

A

B

C

B

A

B

C

3

11

B

A

B

C

A

B

A

B

A

B

A

B

A

C

A

1

12

A

B

C

A

C

A

C

A

C

B

C

A

B

A

B

C

A

3

13

C

B

C

A

B

C

A

B

C

A

C

A

B

A

3

14

B

C

B

A

C

A

B

C

A

B

A

B

4

15

B

C

B

A

B

A

B

C

A

B

C

A

C

B

3

16

B

A

C

B

A

C

A

B

A

B

A

C

B

A

B

2

17

B

A

B

A

B

A

B

A

B

C

B

A

3

18

B

A

B

A

C

B

C

A

C

B

C

A

B

C

1

19

A

B

A

B

A

B

C

A

B

C

B

A

C

3

20

A

C

A

B

A

B

A

B

C

B

A

C

A

C

A

C

2

21

C

B

A

B

A

B

A

C

B

C

A

B

C

B

3

=STREAK(B3#,"a",,1)

22

B

A

B

C

A

C

A

C

A

C

A

B

A

C

2

4

23

24

2

3

2

3

2

3

9

2

4

3

2

3

1

3

25

=STREAK(B3#,"a",1)

26

9

27

=STREAK(B3#,"a",1,1)

28

Sheet1

Cell Formulas
Range	Formula
B2,Y21,W2	B2	=FORMULATEXT(B3)
B3:U22	B3	=CHAR(RANDARRAY(20,20,65,67,1))
W3:W22	W3	=STREAK(B3#,"a")
Y22	Y22	=STREAK(B3#,"a",,1)
B24:U24	B24	=STREAK(B3#,"a",1)
B25,U27	B25	=FORMULATEXT(B24)
U26	U26	=STREAK(B3#,"a",1,1)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:U22	Expression	=B3="a"	text	NO

Xlambda · Oct 4, 2022

I know, can be modified with ease, that's why I have mentioned above "min corespondent length". Next break will do, since I'm at work.

Xlambda · Oct 4, 2022

Revised ROWSTREAK(a,[v],[n],[lf]) Calls STREAKS
a: array
[v]: single value or array of values, if omitted, all unique values of "ar" are considered
[n]: numeric value length/frequency, if omitted max(length)/max(frequency) triggered by "lf" argument
[lf]: length/frequency argument, if omitted=> frequencies, if 1=> lengths, if n=0 and lf=2=>lengths of max frequencies

Excel Formula:

=LAMBDA(a, [v], [n], [lf],
    LET(
        b, STREAKS(a, v),
        m, MAP(
            DROP(b, 1),
            LAMBDA(x,
                LET(
                    f, --TEXTSPLIT(x, ","),
                    y, MAX(f),
                    ml, COLUMNS(f),
                    l, SEQUENCE(, ml),
                    IF(n, IF(lf, INDEX(f, n), TEXTJOIN(",", , IF(f = n, l, ""))), IF(lf, IF(lf = 1, ml, y & ";" & TEXTJOIN(",", , IF(f = y, l, ""))), y))
                )
            )
        ),
        e, IFERROR(VSTACK(TAKE(b, 1), m), 0),
        IFERROR(--e, e)
    )
)

STREAK.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

1

all values, max frequencies

all values, max lengths

all values, max frequencies and their lengths

2

v, omitted=>all values

3

n, omitted,max

4

lf, omitted=> frequencies

lf,1=> lengths

lf,2=> max frequencies; corespondent lengths

5

6

B

C

A

B

C

A

B

C

A

B

C

7

7,0,2,1

7,0,1

11,1

7

11

4

3

2

7;1

11;1

8

4,4

6,4

5,1,1,1

4

6

5

2

4

4;1,2

6;1

5;1

9

7,3,2

8,0,1

4,0,2

7

8

4

3

7;1

8;1

4;1

10

9,1

7,1,0,1

7,1,1,1

9

7

2

4

9;1

7;1

11

6,1,2

5,2,1,1

2,4

6

5

4

3

4

2

6;1

5;1

4;2

12

13

lengths for frequencies=1

frequencies for length=1

14

v, omitted=>all values

15

n, 1

16

lf, omitted=> frequencies

lf,1=> lengths

17

=ROWSTREAK(ar,,1)

=ROWSTREAK(ar,,1,1)

18

A

B

C

A

B

C

19

4

3

2

7

11

20

2,3,4

4

6

5

21

3

7

8

4

22

2

2,4

2,3,4

9

7

23

2

3,4

6

5

2

24

25

lengths for frequencies=2

frequencies for length=2

26

v, omitted=>all values

27

n, 2

28

lf, omitted=> frequencies

lf,1=> lengths

29

=ROWSTREAK(ar,,2)

=ROWSTREAK(ar,,2,1)

30

A

B

C

A

B

C

31

3

0

1

32

4

1

33

3

0

34

1

35

3

2

1

2

4

36

37

lengths for frequencies=4

frequencies for length=4

38

v, omitted=>all values

39

n, 4

40

lf, omitted=> frequencies

lf,1=> lengths

41

=ROWSTREAK(ar,,4)

=ROWSTREAK(ar,,4,1)

42

A

B

C

A

B

C

43

1

0

44

1,2

2

0

1

45

1

0

46

0

1

47

2

0

1

0

48

ROWSTREAK 1

Cell Formulas
Range	Formula
B5,K41,F41,K29,F29,K17,F17,P5,K5,F5	B5	=FORMULATEXT(B6)
B6:D11	B6	=STREAKS(ar)
F6:H11	F6	=ROWSTREAK(ar)
K6:M11	K6	=ROWSTREAK(ar,,,1)
P6:R11	P6	=ROWSTREAK(ar,,,2)
F18:H23	F18	=ROWSTREAK(ar,,1)
K18:M23	K18	=ROWSTREAK(ar,,1,1)
F30:H35	F30	=ROWSTREAK(ar,,2)
K30:M35	K30	=ROWSTREAK(ar,,2,1)
F42:H47	F42	=ROWSTREAK(ar,,4)
K42:M47	K42	=ROWSTREAK(ar,,4,1)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
ar	=ROWSTREAK!$B$4:$AO$8	B6, F6, F18, F30, F42, K6, K18, K30, K42, P6

st001 · Oct 4, 2022

Amazing! How you think of these challenges, its quite amazing!

first IF statement should be, me thinks... but totally cool function!

Excel Formula:

    IF(
          lf,
            TEXTJOIN(",", , IF(f = n, l, "")),
            INDEX(f, n)
   ),

Xlambda · Oct 9, 2022

st001 said:
Amazing! How you think of these challenges, its quite amazing!

first IF statement should be, me thinks... but totally cool function!

Excel Formula:

IF( lf, TEXTJOIN(",", , IF(f = n, l, "")), INDEX(f, n) ),

Long time no see

Back on track!!
The IF "flow" is like this (nested IF) and works fine:
IF( n, IF( lf , INDEX , TJ1 ) , IF( lf , IF( lf=1, ml, y&TJ2 ) ,y ) )

st001 · Oct 9, 2022

Thanks!

I'm started using a modified version of your excellent work here:

I can't remember what I changed, I think
- I swapped the arguments in the first IF, so if the last argument of the Lamdba was 0 or 1, it always returned a length or frequency, regardless of whether n was blank or not.
- Then I redefined ml, in case there were any '0' cases, as I was getting iffy results if a character appeared on one row, but not others.

But, as I say, its a superb function, and thanks for sharing. There so much you can do with Lamdbas, it's truly quite amazing.
I'm trying to find the hi-fi emoji, is this it?

Excel Formula:

AROWSTREAK = LAMBDA(a, [v], [n], [lf],
    LET(
        b, ASTREAKS(a, v),
        m, MAP(
            DROP(b, 1),
            LAMBDA(x,
                LET(
                    f, --TEXTSPLIT(x, ","),
                    y, MAX(f),
                    ml, IF(y = 0, 0, COLUMNS(f)),
                    l, SEQUENCE(, ml),
                    IF(
                        n,
                        IF(
                            lf,
                            TEXTJOIN(",", , IF(f = n, l, "")),
                            INDEX(f, n)
                        ),
                        IF(
                            lf,
                            IF(
                                lf = 1,
                                ml,
                                y & ";" & TEXTJOIN(",", , IF(f = y, l, ""))
                            ),
                            y
                        )
                    )
                )
            )
        ),
        e, IFERROR(VSTACK(TAKE(b, 1), m), 0),
        IFERROR(--e, e)
    )
);

Xlambda · Oct 9, 2022

Thanks, and very good point !

If we have to overcome the cases when a value is not found on a row, if I leave the IF "flow" as it is, modifying only "ml" var to IF(y, COLUMNS(f), 0) will do the trick.
Maybe with this we can get out from beta version.

.
Regarding the complexity of lambdas, I think we are only scratching the surface. I have so many functions and concepts that are waiting to be posted. Editing the mini-sheets to a minimal standard quality is so time consuming that I do not know if I will ever catch up. The only way is to work on the go.
ROWSTREAK(a,[v],[n],[lf]) Calls STREAKS
a: array
[v]: single value or array of values, if omitted, all unique values of "ar" are considered
[n]: numeric value length/frequency, if omitted max(length)/max(frequency) triggered by "lf" argument
[lf]: length/frequency argument, if omitted=> frequencies, if 1=> lengths, if n=0 and lf=2=>max frequencies and their lengths.

Excel Formula:

=LAMBDA(a, [v], [n], [lf],
    LET(
        b, STREAKS(a, v),
        m, MAP(
            DROP(b, 1),
            LAMBDA(x,
                LET(
                    f, --TEXTSPLIT(x, ","),
                    y, MAX(f),
                    ml, IF(y, COLUMNS(f), 0),
                    l, SEQUENCE(, ml),
                    IF(n, IF(lf, INDEX(f, n), TEXTJOIN(",", , IF(f = n, l, ""))), IF(lf, IF(lf = 1, ml, y & ";" & TEXTJOIN(",", , IF(f = y, l, ""))), y))
                )
            )
        ),
        e, IFERROR(VSTACK(TAKE(b, 1), m), 0),
        IFERROR(--e, e)
    )
)

With this sample data, every row is missing a value, so whatever arguments we are triggering, will always have 0's or ""'s diagonal.

STREAK.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

1

2

defined name "ay" = B4:AO8

3

4

A

B

A

B

A

B

A

B

A

B

5

C

A

C

A

C

A

C

A

C

6

B

C

B

C

B

C

B

7

ROWSTREAK 2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:U6	Expression	=B6="c"	text	NO
B6:U6	Expression	=B6="b"	text	NO
B6:U6	Expression	=B6="a"	text	NO
B4:U5	Expression	=B4="c"	text	NO
B4:U5	Expression	=B4="b"	text	NO
B4:U5	Expression	=B4="a"	text	NO

Xlambda · Oct 9, 2022

STREAK.xlsx

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

AH

AI

AJ

AK

AL

AM

AN

1

max frequencies

lengths for frequencies=1

frequencies for lengths=1

2

=STREAKS(ay)

n,lf, omitted

n,1,lf,omitted

n,1,lf,1

3

A

B

C

=ROWSTREAK(ay)

=ROWSTREAK(ay,,1)

=ROWSTREAK(ay,,1,1)

4

1,2,2

2,3

0

A

B

C

A

B

C

A

B

C

5

0,3,0,1

0

1,4

2

3

0

1

2

0

6

0

0,1,0,3

1,2

3

0

4

1

0

1

7

0

3

2

1

0

1

8

9

max lengths

lengths for frequencies=2

frequencies for lengths=2

10

n,omitted,lf,1

n,2,lf,omitted

n,2,lf,1

11

12

B

C

A

B

C

A

B

C

13

3

2

0

2,3

1

2

3

0

14

4

0

2

3

0

4

15

0

4

2

0

1

2

16

17

max frq; coresp. lengths

lengths for frequencies=3

frequencies for lengths=3

18

n,omitted,lf,2

n,3,lf,omitted

n,3,lf,1

19

20

B

C

A

B

C

A

B

C

21

2;2,3

3;2

0

2

0

22

3;2

0

4;2

2

0

23

0

3;4

2;2

4

0

24

25

lengths for frequencies=4

frequencies for lengths=4

26

n,4,lf,omitted

n,4,lf,1

27

=ROWSTREAK(ay,,4)

=ROWSTREAK(ay,,4,1)

28

A

B

C

A

B

C

29

0

30

2

1

0

31

0

3

0

32

ROWSTREAK 2

Cell Formulas
Range	Formula
W2,AE27,AI27,AA19,AE19,AI19,AA11,AE11,AI11,AE3,AI3,AA3	W2	=FORMULATEXT(W3)
W3:Y6	W3	=STREAKS(ay)
AA4:AC7	AA4	=ROWSTREAK(ay)
AE4:AG7	AE4	=ROWSTREAK(ay,,1)
AI4:AK7	AI4	=ROWSTREAK(ay,,1,1)
AA12:AC15	AA12	=ROWSTREAK(ay,,,1)
AE12:AG15	AE12	=ROWSTREAK(ay,,2)
AI12:AK15	AI12	=ROWSTREAK(ay,,2,1)
AA20:AC23	AA20	=ROWSTREAK(ay,,,2)
AE20:AG23	AE20	=ROWSTREAK(ay,,3)
AI20:AK23	AI20	=ROWSTREAK(ay,,3,1)
AE28:AG31	AE28	=ROWSTREAK(ay,,4)
AI28:AK31	AI28	=ROWSTREAK(ay,,4,1)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
ay	='ROWSTREAK 2'!$B$4:$T$6	AI28, AI20, AI12, AI4, AE28, AE20, AE12, AE4, AA20, AA12, AA4, W3

Xlambda · Oct 9, 2022

Extracting data from STREAKS 4D array(values, bycol, lengths, frequencies)
Chose 2 separate functions, and not one that embeds both, because it would have added an extra argument and with 3 arguments is easier to perceive, plus byrow/bycol approach became common in Excel for new functions, safer to use.
The main core part of the function (lambda helper function in MAP) will be identical for both functions, so only a few minor orientation changes to get to COLSTREAK.
COLSTREAK(a,[v],[n],[lf]) Calls STREAKS
a: array
[v]: single value or array of values, if omitted, all unique values of "ar" are considered
[n]: numeric value length/frequency, if omitted max(length)/max(frequency) triggered by "lf" argument
[lf]: length/frequency argument, if omitted=> frequencies, if 1=> lengths, if n=0 and lf=2=>max frequencies and their lengths.

Excel Formula:

=LAMBDA(a, [v], [n], [lf],
    LET(
        b, STREAKS(a, v, 1),
        m, MAP(
            DROP(b, , 1),
            LAMBDA(x,
                LET(
                    f, --TEXTSPLIT(x, ","),
                    y, MAX(f),
                    ml, IF(y, COLUMNS(f), 0),
                    l, SEQUENCE(, ml),
                    IF(n, IF(lf, INDEX(f, n), TEXTJOIN(",", , IF(f = n, l, ""))), IF(lf, IF(lf = 1, ml, y & ";" & TEXTJOIN(",", , IF(f = y, l, ""))), y))
                )
            )
        ),
        e, IFERROR(HSTACK(TAKE(b, , 1), m), 0),
        IFERROR(--e, e)
    )
)

STREAK.xlsx

A

B

C

D

E

F

G

H

1

2

defined name "br" = B4:F43

3

4

br

C

A

C

A

5

C

B

C

A

B

6

B

C

B

A

7

A

C

B

A

C

8

C

B

A

B

9

A

C

A

C

A

10

A

B

11

A

C

A

12

C

B

C

A

C

13

C

B

C

14

B

C

A

C

15

A

B

C

16

B

A

B

C

17

A

B

C

18

A

B

A

19

C

B

A

B

20

A

B

C

A

21

A

B

22

C

A

B

A

C

23

A

C

B

A

24

A

C

A

25

A

C

A

C

A

26

A

B

A

27

B

A

B

A

C

28

A

C

B

A

29

B

C

A

C

30

A

C

A

B

A

31

C

A

B

A

32

A

C

A

B

33

C

A

B

C

34

C

B

35

C

B

A

36

B

C

B

37

B

A

B

A

C

38

A

C

39

B

C

B

A

40

B

A

B

41

B

A

C

A

42

C

B

A

C

43

A

B

C

A

44

COLSTREAK

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:F43	Expression	=B4="c"	text	NO
B4:F43	Expression	=B4="b"	text	NO
B4:F43	Expression	=B4="a"	text	NO

Xlambda · Oct 9, 2022

STREAK.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

1

all values, max frequencies

all values, max lengths

all values, lengths of max frequencies

2

=STREAKS(br,,1)

v, omitted=>all values

3

A

7,2,1,1

4,4

2,3,2

7,3,1

11,1,0,1

n, omitted,max

4

B

5,1,1

4,1,1,0,1

5,0,1,1,0,0,0,1

8,2

9

lf, omitted=> frequencies

lf,1=> lengths

lf,2=> max frequencies; corespondent lengths

5

C

5,2,1

1,1,1,2

4,1

10,1

6,1,0,0,0,1

6

7

4

3

7

11

A

4

2

3

4

A

7;1

4;1,2

3;2

7;1

11;1

7

B

5

4

5

8

9

B

3

5

8

2

1

B

5;1

4;1

5;1

8;1

9;1

8

C

5

2

4

10

6

C

3

4

2

6

C

5;1

2;4

4;1

10;1

6;1

9

10

lengths for frequencies=1

frequencies for length=1

11

v, omitted=>all values

12

n, 1

13

lf, omitted=> frequencies

lf,1=> lengths

14

=COLSTREAK(br,,1)

=COLSTREAK(br,,1,1)

15

A

3,4

3

2,4

A

7

4

2

7

11

16

B

2,3

2,3,5

3,4,8

B

5

4

5

8

9

17

C

3

1,2,3

2

2,6

C

5

1

4

10

6

18

19

lengths for frequencies=2

frequencies for length=2

20

v, omitted=>all values

21

n, 2

22

lf, omitted=> frequencies

lf,1=> lengths

23

=COLSTREAK(br,,2)

=COLSTREAK(br,,2,1)

24

A

2

1,3

A

2

4

3

1

25

B

2

B

1

0

2

0

26

C

2

4

C

2

1

27

28

lengths for frequencies=4

frequencies for length=4

29

v, omitted=>all values

30

n, 4

31

lf, omitted=> frequencies

lf,1=> lengths

32

33

1,2

1

0

1

34

B

1

B

0

1

0

35

C

1

C

0

2

0

36

COLSTREAK 1

Cell Formulas
Range	Formula
B2,P32,I32,P23,I23,P14,I14,W5,P5,I5	B2	=FORMULATEXT(B3)
B3:G5	B3	=STREAKS(br,,1)
I6:N8	I6	=COLSTREAK(br)
P6:U8	P6	=COLSTREAK(br,,,1)
W6:AB8	W6	=COLSTREAK(br,,,2)
I15:N17	I15	=COLSTREAK(br,,1)
P15:U17	P15	=COLSTREAK(br,,1,1)
I24:N26	I24	=COLSTREAK(br,,2)
P24:U26	P24	=COLSTREAK(br,,2,1)
I33:N35	I33	=COLSTREAK(br,,4)
P33:U35	P33	=COLSTREAK(br,,4,1)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
br	=COLSTREAK!$B$4:$F$43	B3, I6, I15, I24, I33, P6, P15, P24, P33, W6

Xlambda · Oct 9, 2022

With this sample data, every clm is missing a value, so whatever arguments we are triggering, will always have 0's or ""'s diagonal.

STREAK.xlsx

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

1

2

defined name "by" = B4:D22

max frequencies

lengths for frequencies=1

frequencies for lengths=1

3

n,lf, omitted

n,1,lf,omitted

n,1,lf,1

4

by

A

C

B

5

A

B

A

1,2,2

0,3,0,1

0

A

2

3

0

A

1

4

A

1

0

6

A

C

B

2,3

0

0,1,0,3

B

3

0

3

B

2

B

2

0

7

B

C

0

1,4

1,2

C

0

4

2

C

1

C

0

1

8

B

C

B

9

A

B

max lengths

lengths for frequencies=2

frequencies for lengths=2

10

A

B

n,omitted,lf,1

n,2,lf,omitted

n,2,lf,1

11

B

C

B

=COLSTREAK(by,,,1)

=COLSTREAK(by,,2)

=COLSTREAK(by,,2,1)

12

B

C

A

3

4

0

A

2,3

A

2

3

0

13

A

C

B

2

0

4

B

1

B

3

0

1

14

A

B

C

0

2

C

2

C

0

4

2

15

A

C

B

16

B

C

B

max frq; coresp. lengths

lengths for frequencies=3

frequencies for lengths=3

17

B

A

B

n,omitted,lf,2

n,3,lf,omitted

n,3,lf,1

18

A

C

=COLSTREAK(by,,,2)

=COLSTREAK(by,,3)

=COLSTREAK(by,,3,1)

19

A

B

A

2;2,3

3;2

0

A

2

A

2

0

20

B

A

B

3;2

0

3;4

B

2

4

B

0

21

A

C

B

C

0

4;2

2;2

C

0

22

B

C

B

23

lengths for frequencies=4

frequencies for lengths=4

24

n,4,lf,omitted

n,4,lf,1

25

=COLSTREAK(by,,4)

=COLSTREAK(by,,4,1)

26

A

0

1

0

27

B

0

3

28

C

2

C

0

29

COLSTREAK 2

Cell Formulas
Range	Formula
G4,V25,Q25,V18,Q18,L18,V11,Q11,L11,V4,Q4,L4	G4	=FORMULATEXT(G5)
G5:J7	G5	=STREAKS(by,,1)
L5:O7	L5	=COLSTREAK(by)
Q5:T7	Q5	=COLSTREAK(by,,1)
V5:Y7	V5	=COLSTREAK(by,,1,1)
L12:O14	L12	=COLSTREAK(by,,,1)
Q12:T14	Q12	=COLSTREAK(by,,2)
V12:Y14	V12	=COLSTREAK(by,,2,1)
L19:O21	L19	=COLSTREAK(by,,,2)
Q19:T21	Q19	=COLSTREAK(by,,3)
V19:Y21	V19	=COLSTREAK(by,,3,1)
Q26:T28	Q26	=COLSTREAK(by,,4)
V26:Y28	V26	=COLSTREAK(by,,4,1)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
by	='COLSTREAK 2'!$B$4:$D$22	V26, V19, V12, V5, Q26, Q19, Q12, Q5, L19, L12, L5, G5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:D22	Expression	=B4="c"	text	NO
B4:D22	Expression	=B4="b"	text	NO
B4:D22	Expression	=B4="a"	text	NO

STREAK

Xlambda

Well-known Member

Xlambda

Well-known Member

Xlambda

Well-known Member

st001

New Member

Xlambda

Well-known Member

st001

New Member

Xlambda

Well-known Member

Xlambda

Well-known Member

Xlambda

Well-known Member

Xlambda

Well-known Member

Xlambda

Well-known Member

Forum statistics

Share this page

STREAK

Well-known Member

Well-known Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock