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?

	team													result-1	result-2	result-X
	arsenal	1	1	1	1	X	1	2	2	2	1	2	X	=4	=3	=1
	manchester	X	X	X	2	X	X	1	X	X	1	1	1	=3	=1	=3

<tbody>
</tbody>

 

[Sixthsense]

Not clear about how you arriving the results

 

[xaritona89]

result-1

result-2

result-X

<tbody>
</tbody>

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)

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

<tbody>
</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