shorten 2 divide formulas

[excelNewbie22]

hi, how can i shorten this into one? but by counting the true ones (sum?)

test.xlsb
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2	1	2	3	4	5	6	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	TRUE	TRUE	FALSE	TRUE	TRUE
test

Cell Formulas
Range	Formula
I2	I2	=MOD(H2,G2)=0
J2	J2	=MOD(H2,F2)=0
K2	K2	=MOD(H2,E2)=0
L2	L2	=MOD(H2,D2)=0
M2	M2	=MOD(H2,C2)=0
N2	N2	=MOD(G2,F2)=0
O2	O2	=MOD(G2,E2)=0
P2	P2	=MOD(G2,D2)=0
Q2	Q2	=MOD(G2,C2)=0
R2	R2	=MOD(F2,E2)=0
S2	S2	=MOD(F2,D2)=0
T2	T2	=MOD(F2,C2)=0
U2	U2	=MOD(E2,D2)=0
V2	V2	=MOD(E2,C2)=0
W2	W2	=MOD(D2,C2)=0

same thing to this one?

test.xlsb
	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	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB
2	1	2	3	4	5	6	TRUE	TRUE	FALSE	TRUE	FALSE	FALSE	TRUE	TRUE	FALSE	TRUE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
3	7	8	9	10	11	12	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
test

Cell Formulas
Range	Formula
I2	I2	=MOD(C1,C2)=0
J2	J2	=MOD(C1,D2)=0
K2	K2	=MOD(C1,E2)=0
L2	L2	=MOD(C1,F2)=0
M2	M2	=MOD(C1,G2)=0
N2	N2	=MOD(C1,H2)=0
O2	O2	=MOD(D1,C2)=0
P2	P2	=MOD(D1,D2)=0
Q2	Q2	=MOD(D1,E2)=0
R2	R2	=MOD(D1,F2)=0
S2	S2	=MOD(D1,G2)=0
T2	T2	=MOD(D1,H2)=0
U2	U2	=MOD(E1,C2)=0
V2	V2	=MOD(E1,D2)=0
W2	W2	=MOD(E1,E2)=0
X2	X2	=MOD(E1,F2)=0
Y2	Y2	=MOD(E1,G2)=0
Z2	Z2	=MOD(E1,H2)=0
AA2	AA2	=MOD(F1,C2)=0
AB2	AB2	=MOD(F1,D2)=0
AC2	AC2	=MOD(F1,E2)=0
AD2	AD2	=MOD(F1,F2)=0
AE2	AE2	=MOD(F1,G2)=0
AF2	AF2	=MOD(F1,H2)=0
AG2	AG2	=MOD(G1,C2)=0
AH2	AH2	=MOD(G1,D2)=0
AI2	AI2	=MOD(G1,E2)=0
AJ2	AJ2	=MOD(G1,F2)=0
AK2	AK2	=MOD(G1,G2)=0
AL2	AL2	=MOD(G1,H2)=0
AM2	AM2	=MOD(H1,C2)=0
AN2	AN2	=MOD(H1,D2)=0
AO2	AO2	=MOD(H1,E2)=0
AP2	AP2	=MOD(H1,F2)=0
AQ2	AQ2	=MOD(H1,G2)=0
AR2	AR2	=MOD(H1,H2)=0
AS2	AS2	=MOD(C2,C1)=0
AT2	AT2	=MOD(C2,D1)=0
AU2	AU2	=MOD(C2,E1)=0
AV2	AV2	=MOD(C2,F1)=0
AW2	AW2	=MOD(C2,G1)=0
AX2	AX2	=MOD(C2,H1)=0
AY2	AY2	=MOD(D2,C1)=0
AZ2	AZ2	=MOD(D2,D1)=0
BA2	BA2	=MOD(D2,E1)=0
BB2	BB2	=MOD(D2,F1)=0
BC2	BC2	=MOD(D2,G1)=0
BD2	BD2	=MOD(D2,H1)=0
BE2	BE2	=MOD(E2,C1)=0
BF2	BF2	=MOD(E2,D1)=0
BG2	BG2	=MOD(E2,E1)=0
BH2	BH2	=MOD(E2,F1)=0
BI2	BI2	=MOD(E2,G1)=0
BJ2	BJ2	=MOD(E2,H1)=0
BK2	BK2	=MOD(F2,C1)=0
BL2	BL2	=MOD(F2,D1)=0
BM2	BM2	=MOD(F2,E1)=0
BN2	BN2	=MOD(F2,F1)=0
BO2	BO2	=MOD(F2,G1)=0
BP2	BP2	=MOD(F2,H1)=0
BQ2	BQ2	=MOD(G2,C1)=0
BR2	BR2	=MOD(G2,D1)=0
BS2	BS2	=MOD(G2,E1)=0
BT2	BT2	=MOD(G2,F1)=0
BU2	BU2	=MOD(G2,G1)=0
BV2	BV2	=MOD(G2,H1)=0
BW2	BW2	=MOD(H2,C1)=0
BX2	BX2	=MOD(H2,D1)=0
BY2	BY2	=MOD(H2,E1)=0
BZ2	BZ2	=MOD(H2,F1)=0
CA2	CA2	=MOD(H2,G1)=0
CB2,BW3	CB2	=MOD(H2,H1)=0
I3	I3	=MOD(C2,D2)=0
J3	J3	=MOD(C2,E2)=0
K3	K3	=MOD(C2,F2)=0
L3	L3	=MOD(C2,G2)=0
M3	M3	=MOD(C2,H2)=0
N3	N3	=MOD(C2,C3)=0
O3	O3	=MOD(C2,D3)=0
P3	P3	=MOD(C2,E3)=0
Q3	Q3	=MOD(C2,F3)=0
R3	R3	=MOD(C2,G3)=0
S3	S3	=MOD(C2,H3)=0
T3	T3	=MOD(D2,C2)=0
U3	U3	=MOD(D2,E2)=0
V3	V3	=MOD(D2,F2)=0
W3	W3	=MOD(D2,G2)=0
X3	X3	=MOD(D2,H2)=0
Y3	Y3	=MOD(D2,C3)=0
Z3	Z3	=MOD(D2,D3)=0
AA3	AA3	=MOD(D2,E3)=0
AB3	AB3	=MOD(D2,F3)=0
AC3	AC3	=MOD(D2,G3)=0
AD3	AD3	=MOD(D2,H3)=0
AE3	AE3	=MOD(E2,C2)=0
AF3	AF3	=MOD(E2,D2)=0
AG3	AG3	=MOD(E2,F2)=0
AH3	AH3	=MOD(E2,G2)=0
AI3	AI3	=MOD(E2,H2)=0
AJ3	AJ3	=MOD(E2,C3)=0
AK3	AK3	=MOD(E2,D3)=0
AL3	AL3	=MOD(E2,E3)=0
AM3	AM3	=MOD(E2,F3)=0
AN3	AN3	=MOD(E2,G3)=0
AO3	AO3	=MOD(E2,H3)=0
AP3	AP3	=MOD(F2,C2)=0
AQ3	AQ3	=MOD(F2,D2)=0
AR3	AR3	=MOD(F2,E2)=0
AS3	AS3	=MOD(F2,G2)=0
AT3	AT3	=MOD(F2,H2)=0
AU3	AU3	=MOD(F2,C3)=0
AV3	AV3	=MOD(F2,D3)=0
AW3	AW3	=MOD(F2,E3)=0
AX3	AX3	=MOD(F2,F3)=0
AY3	AY3	=MOD(F2,G3)=0
AZ3	AZ3	=MOD(F2,H3)=0
BA3	BA3	=MOD(G2,C2)=0
BB3	BB3	=MOD(G2,D2)=0
BC3	BC3	=MOD(G2,E2)=0
BD3	BD3	=MOD(G2,F2)=0
BE3	BE3	=MOD(G2,H2)=0
BF3	BF3	=MOD(G2,C3)=0
BG3	BG3	=MOD(G2,D3)=0
BH3	BH3	=MOD(G2,E3)=0
BI3	BI3	=MOD(G2,F3)=0
BJ3	BJ3	=MOD(G2,G3)=0
BK3	BK3	=MOD(G2,H3)=0
BL3	BL3	=MOD(H2,C2)=0
BM3	BM3	=MOD(H2,D2)=0
BN3	BN3	=MOD(H2,E2)=0
BO3	BO3	=MOD(H2,F2)=0
BP3	BP3	=MOD(H2,G2)=0
BQ3	BQ3	=MOD(H2,C3)=0
BR3	BR3	=MOD(H2,D3)=0
BS3	BS3	=MOD(H2,E3)=0
BT3	BT3	=MOD(H2,F3)=0
BU3	BU3	=MOD(H2,G3)=0
BV3	BV3	=MOD(H2,H3)=0
BX3	BX3	=MOD(C3,D2)=0
BY3	BY3	=MOD(C3,E2)=0
BZ3	BZ3	=MOD(C3,F2)=0
CA3	CA3	=MOD(C3,G2)=0
CB3	CB3	=MOD(C3,H2)=0

 

[excelNewbie22]

had a mistake in the second sample, here's a fix

test.xlsb
	C	D	E	F	G	H
2	1	2	3	4	5	6
3	7	8	9	10	11	12
test

test.xlsb
	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS
3	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
test

Cell Formulas
Range	Formula
Z3	Z3	=MOD(C2,D2)=0
AA3	AA3	=MOD(C2,E2)=0
AB3	AB3	=MOD(C2,F2)=0
AC3	AC3	=MOD(C2,G2)=0
AD3	AD3	=MOD(C2,H2)=0
AE3	AE3	=MOD(C2,C3)=0
AF3	AF3	=MOD(C2,D3)=0
AG3	AG3	=MOD(C2,E3)=0
AH3	AH3	=MOD(C2,F3)=0
AI3	AI3	=MOD(C2,G3)=0
AJ3	AJ3	=MOD(C2,H3)=0
AK3	AK3	=MOD(D2,C2)=0
AL3	AL3	=MOD(D2,E2)=0
AM3	AM3	=MOD(D2,F2)=0
AN3	AN3	=MOD(D2,G2)=0
AO3	AO3	=MOD(D2,H2)=0
AP3	AP3	=MOD(D2,C3)=0
AQ3	AQ3	=MOD(D2,D3)=0
AR3	AR3	=MOD(D2,E3)=0
AS3	AS3	=MOD(D2,F3)=0
AT3	AT3	=MOD(D2,G3)=0
AU3	AU3	=MOD(D2,H3)=0
AV3	AV3	=MOD(E2,C2)=0
AW3	AW3	=MOD(E2,D2)=0
AX3	AX3	=MOD(E2,F2)=0
AY3	AY3	=MOD(E2,G2)=0
AZ3	AZ3	=MOD(E2,H2)=0
BA3	BA3	=MOD(E2,C3)=0
BB3	BB3	=MOD(E2,D3)=0
BC3	BC3	=MOD(E2,E3)=0
BD3	BD3	=MOD(E2,F3)=0
BE3	BE3	=MOD(E2,G3)=0
BF3	BF3	=MOD(E2,H3)=0
BG3	BG3	=MOD(F2,C2)=0
BH3	BH3	=MOD(F2,D2)=0
BI3	BI3	=MOD(F2,E2)=0
BJ3	BJ3	=MOD(F2,G2)=0
BK3	BK3	=MOD(F2,H2)=0
BL3	BL3	=MOD(F2,C3)=0
BM3	BM3	=MOD(F2,D3)=0
BN3	BN3	=MOD(F2,E3)=0
BO3	BO3	=MOD(F2,F3)=0
BP3	BP3	=MOD(F2,G3)=0
BQ3	BQ3	=MOD(F2,H3)=0
BR3	BR3	=MOD(G2,C2)=0
BS3	BS3	=MOD(G2,D2)=0
BT3	BT3	=MOD(G2,E2)=0
BU3	BU3	=MOD(G2,F2)=0
BV3	BV3	=MOD(G2,H2)=0
BW3	BW3	=MOD(G2,C3)=0
BX3	BX3	=MOD(G2,D3)=0
BY3	BY3	=MOD(G2,E3)=0
BZ3	BZ3	=MOD(G2,F3)=0
CA3	CA3	=MOD(G2,G3)=0
CB3	CB3	=MOD(G2,H3)=0
CC3	CC3	=MOD(H2,C2)=0
CD3	CD3	=MOD(H2,D2)=0
CE3	CE3	=MOD(H2,E2)=0
CF3	CF3	=MOD(H2,F2)=0
CG3	CG3	=MOD(H2,G2)=0
CH3	CH3	=MOD(H2,C3)=0
CI3	CI3	=MOD(H2,D3)=0
CJ3	CJ3	=MOD(H2,E3)=0
CK3	CK3	=MOD(H2,F3)=0
CL3	CL3	=MOD(H2,G3)=0
CM3	CM3	=MOD(H2,H3)=0
CN3	CN3	=MOD(C3,C2)=0
CO3	CO3	=MOD(C3,D2)=0
CP3	CP3	=MOD(C3,E2)=0
CQ3	CQ3	=MOD(C3,F2)=0
CR3	CR3	=MOD(C3,G2)=0
CS3	CS3	=MOD(C3,H2)=0

 

[JGordon11]

If your values in columns C to H are increasing (i.e., C2 less than or equal to D2, D2 less than or equal to E2, ..., G2 less than or equal to H2) the formula in column Y below should work. As you can see in the examples in rows 7 and 8 where the values are not in increasing order, the formula does not return the same value as the count of the trues in Columns I to W.

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
1			Increasing
2			1	2	3	4	5	6	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	TRUE	TRUE	FALSE	TRUE	TRUE	8	8	MATCH
3			1	2	3	4	6	6	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	FALSE	TRUE	TRUE	11	11	MATCH
4			1	2	2	4	6	6	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	13	13	MATCH
5
6			Not Increasing
7			6	6	4	2	2	1	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	2	13	ERROR
8			3	6	3	6	3	6	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	12	15	ERROR
9
Sheet1

Cell Formulas
Range	Formula
I2:I4,I7:I8	I2	=MOD(H2,G2)=0
J2:J4,J7:J8	J2	=MOD(H2,F2)=0
K2:K4,K7:K8	K2	=MOD(H2,E2)=0
L2:L4,L7:L8	L2	=MOD(H2,D2)=0
M2:M4,M7:M8	M2	=MOD(H2,C2)=0
N2:N4,N7:N8	N2	=MOD(G2,F2)=0
O2:O4,O7:O8	O2	=MOD(G2,E2)=0
P2:P4,P7:P8	P2	=MOD(G2,D2)=0
Q2:Q4,Q7:Q8	Q2	=MOD(G2,C2)=0
R2:R4,R7:R8	R2	=MOD(F2,E2)=0
S2:S4,S7:S8	S2	=MOD(F2,D2)=0
T2:T4,T7:T8	T2	=MOD(F2,C2)=0
U2:U4,U7:U8	U2	=MOD(E2,D2)=0
V2:V4,V7:V8	V2	=MOD(E2,C2)=0
W2:W4,W7:W8	W2	=MOD(D2,C2)=0
X2:X4,X7:X8	X2	=COUNTIF(I2:W2,TRUE)
Y2:Y4,Y7:Y8	Y2	=LET(a,SORT(C2:H2,,-1),ta, TRANSPOSE(a), b, SUM(--((MOD(a,ta)=0) )), ca, COLUMNS(a), b - (SUM(--(a=ta )) - ca)/2 - ca )
Z2:Z4,Z7:Z8	Z2	=IF(Y2=X2,"MATCH", "ERROR")

 

[jdellasala]

You're doing a Matrix operation and have 365, why not just do:

Book1
	A	B	C	D	E	F	G
1		1	2	3	4	5	6
2	1	0	0	0	0	0	0
3	2	1	0	1	0	1	0
4	3	1	2	0	1	2	0
5	4	1	2	3	0	1	2
6	5	1	2	3	4	0	1
7	6	1	2	3	4	5	0
Sheet1

Cell Formulas
Range	Formula
B1:G1	B1	=SEQUENCE(,6)
A2:A7	A2	=SEQUENCE(6)
B2:G7	B2	=MOD(B1#,A2#)
Dynamic array formulas.

It's not quite what you're looking for, but maybe someone has an idea of how to use some of the newer functions like BYROW to get it all into a single cell formula in the format you want.

I wasn't thinking and fought it until I realized you started at C2! But thanks for using XL2BB - does help!

 

[excelNewbie22]

my apologies for not explaining right,
i want to know how many numbers in c2:h2 divides each other without a remainder,
and same for sample #2 which is c2:h3,
so what i have above is the long way, and i wonder if there's instead one formula to replace it all

test.xlsb
	C	D	E	F	G	H
2	1	2	3	4	5	6
3	4	8	9	10	11	12
test

for c2:h2 - 6 divide with 2, and 3 and 4 divide with 2 and etc
for c2:h3 - 12 divide with 6 and 2 and 3 and 4, 8 divide with 4 and 2 and etc
just to know how many...

 

[jdellasala]

my apologies for not explaining right,
i want to know how many numbers in c2:h2 divides each other without a remainder,
and same for sample #2 which is c2:h3,
so what i have above is the long way, and i wonder if there's instead one formula to replace it all

test.xlsb
	C	D	E	F	G	H
2	1	2	3	4	5	6
3	4	8	9	10	11	12
test

for c2:h2 - 6 divide with 2, and 3 and 4 divide with 2 and etc
for c2:h3 - 12 divide with 6 and 2 and 3 and 4, 8 divide with 4 and 2 and etc
just to know how many...

Just a slight adaptation to get that answer:

Book1
	A	B	C	D	E	F	G	H
1		1	2	3	4	5	6	0 Remainder:
2	1	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	6
3	2	FALSE	TRUE	FALSE	TRUE	FALSE	TRUE	3
4	3	FALSE	FALSE	TRUE	FALSE	FALSE	TRUE	2
5	4	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	1
6	5	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	1
7	6	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	1
8	0 Remainder:	1	2	2	3	2	4	14
9							Row Check:	14
Sheet1

Cell Formulas
Range	Formula
B1:G1	B1	=SEQUENCE(,6)
A2:A7	A2	=SEQUENCE(6)
B2:G7	B2	=MOD(B1#,A2#)=0
B8:G8	B8	=COUNTIFS(B2:B7,TRUE)
H2:H7	H2	=COUNTIFS(B2:G2,TRUE)
H8	H8	=SUM(H2:H7)
H9	H9	=SUM(B8:G8)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:G7	Cell Value	=FALSE	text	NO
B2:G7	Cell Value	=TRUE	text	NO

Just hide or group the rows you don't want/need!

 

[Dave Patton]

What is the expected result?
A guess

T202212a.xlsm
	C	D	E	F	G	H
2	1	2	3	4	5	6
3
4	8
1f

Cell Formulas
Range	Formula
C4	C4	=SUM(--(MOD(H2,C2:G2)=0),--(MOD(G2,C2:F2)=0),--(MOD(F2,C2:E2)=0),--(MOD(E2,C2:D2)=0),--(MOD(D2,C2)=0))

 

[Dave Patton]

What are the expected results

T202212a.xlsm
	A	B	C	D	E	F	G	H
1
2		8	1	2	3	4	5	6
3		2	3	8	9	10	11	12
4
1f

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(--(MOD(H2,C2:G2)=0),--(MOD(G2,C2:F2)=0),--(MOD(F2,C2:E2)=0),--(MOD(E2,C2:D2)=0),--(MOD(D2,C2)=0))

 

[Fluff]

Another option for the 1st part

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1			Increasing
2		8	1	2	3	4	5	6	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	TRUE	TRUE	FALSE	TRUE	TRUE
3		11	1	2	3	4	6	6	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	FALSE	TRUE	TRUE
4		13	1	2	2	4	6	6	TRUE	FALSE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
5
6			Not Increasing
7		2	6	6	4	2	2	1	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
8		12	3	6	3	6	3	6	TRUE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE	FALSE	TRUE	TRUE	TRUE	TRUE	FALSE	TRUE	TRUE
Details

Cell Formulas
Range	Formula
I2:I4,I7:I8	I2	=MOD(H2,G2)=0
J2:J4,J7:J8	J2	=MOD(H2,F2)=0
K2:K4,K7:K8	K2	=MOD(H2,E2)=0
L2:L4,L7:L8	L2	=MOD(H2,D2)=0
M2:M4,M7:M8	M2	=MOD(H2,C2)=0
N2:N4,N7:N8	N2	=MOD(G2,F2)=0
O2:O4,O7:O8	O2	=MOD(G2,E2)=0
P2:P4,P7:P8	P2	=MOD(G2,D2)=0
Q2:Q4,Q7:Q8	Q2	=MOD(G2,C2)=0
R2:R4,R7:R8	R2	=MOD(F2,E2)=0
S2:S4,S7:S8	S2	=MOD(F2,D2)=0
T2:T4,T7:T8	T2	=MOD(F2,C2)=0
U2:U4,U7:U8	U2	=MOD(E2,D2)=0
V2:V4,V7:V8	V2	=MOD(E2,C2)=0
W2:W4,W7:W8	W2	=MOD(D2,C2)=0
B2:B4,B7:B8	B2	=SUM(MAKEARRAY(1,5,LAMBDA(r,c,SUM(--(MOD(INDEX(C2:H2,,c+1),DROP(C2:H2,,c-6))=0)))))

 

[excelNewbie22]

jdellasala - thank you but i need to apply it on thousands of rows

dave and fluff - both of you nailed it! - thanks a lot!

anyone can help with the two rows? c2:h3 ?