count

[xaritona89]

Hello Friends,
please help me,


How do I calculate the same result, which is next?


for example:
result=What formula to write to count the result

1= How many games have won a step by step?
2 = How many games have you lost in step by step?
3 = How many games have played a draw step?


[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]result-1[/TD]
[TD]result-2[/TD]
[TD]result-X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]arsenal[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]X[/TD]
[TD]=4[/TD]
[TD]=3[/TD]
[TD]=1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]manchester[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]2[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]=3[/TD]
[TD]=1[/TD]
[TD]=3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Sixthsense]

Not clear about how you arriving the results

 

[xaritona89]

[TABLE="class: cms_table_grid, width: 200, align: left"]
<tbody>[TR]
[TD]result-1[/TD]
[TD]result-2[/TD]
[TD]result-X[/TD]
[/TR]
</tbody>[/TABLE]




arsenali - result-1=count result 1, only then 1 is by step by step.==4,

arsenal Won the game 4 times in a row(out of X and 2)

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	team													1	2	X
2	arsenal	1	1	1	1	X	1	2	2	2	1	2	X	4	3	1
3	manchester	X	X	X	2	X	X	1	X	X	1	1	1	3	1	3
Sheet2

Cell Formulas
Range	Formula
N2	{=MAX(FREQUENCY(IF($B2:$M2=N$1,COLUMN($B2:$M2)),IF($B2:$M2<>N$1,COLUMN($B2:$M2))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[xaritona89]

thank you very much

 

[Fluff]

You're welcome

 

[xaritona89]

Hello Friends,
please help me,

O and P write result
count >2 and count<2 ( step by step)

team
arsenal	4
manchester	2	1	2	2	3	4	2

<tbody>
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]
[TH="align: center"]C[/TH]
[TH="align: center"]D[/TH]
[TH="align: center"]E[/TH]
[TH="align: center"]F[/TH]
[TH="align: center"]G[/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]
[TH="align: center"]K[/TH]
[TH="align: center"]L[/TH]
[TH="align: center"]M[/TH]
[TH="align: center"]N[/TH]
[TH="align: center"]O[/TH]
[TH="align: center"]P[/TH]

[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]>2[/TD]
[TD="align: right"]<2[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"] 2 [/TD]
[TD="align: right"] 7 [/TD]
[TD="align: right"] 6 [/TD]
[TD="align: right"] 5 [/TD]
[TD="align: right"] 5 [/TD]

[TD="align: right"] =4 [/TD]
[TD="align: right"] =2 [/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"] 2 [/TD]

[TD="align: right"] 5 [/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"] =3 [/TD]
[TD="align: right"] =5 [/TD]
[TD="align: right"][/TD]

</tbody>

 

[Fluff]

Try

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	1	team													2	2
2	2	arsenal	1	3	1	4	4	1	2	7	6	5	5		4	2
3	3	manchester	2	1	2	2	2	3	5	4	2	1	1		3	5
DataDump

Cell Formulas
Range	Formula
O2	{=MAX(FREQUENCY(IF($C2:$M2>O$1,COLUMN($C2:$M2)),IF($C2:$M2<=O$1,COLUMN($C2:$M2))))}
P2	{=MAX(FREQUENCY(IF($C2:$M2<=P$1,COLUMN($C2:$M2)),IF($C2:$M2>P$1,COLUMN($C2:$M2))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[xaritona89]

thank you

 

[Fluff]

You're welcome & thanks for the feedback