Pool Stats

[SquizzleKicks]

Hello,

I am recording individual player stats for my pool team and something I would like to incorporate into this is a current winning or losing streak that will update automatically from me populating a table.

I have mocked up a table as an example, what the formula to do is check the last populated cell and check if it's a 1 or 0, and then check if the previous cell is the same and so on adding them up.

Pool Stats.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1				Game
2		Player	Streak	1	2	3	4	5	6	7	8		Input 1 for Win & 0 for Loss into this table
3		James		1
4		Steve		1
5		Scott		1	1
6		Andrew		0	0
7		Neil		1
8		Skibbs		0
9		Adam		0	1
10		Luke		0
11		Ben		1
12
13				Game
14		Player	Streak	1	2	3	4	5	6	7	8
15		James		W									Output: Green "W" if value =1, Red "L" if value = 0
16		Steve		W									& leave blank if cell is blank
17		Scott		W	W
18		Andrew		L	L								In streak column output:
19		Neil		W									Green number for current W streak
20		Skibbs		L									or Red number for current L Streak
21		Adam		L	W
22		Luke		L
23		Ben		W
Sheet5

Cell Formulas
Range	Formula
D15:K23	D15	=IF(ISBLANK(D3), "",IF(D3=1, "W", "L"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D15:K23	Cell Value	contains "L"	text	NO
D15:K23	Cell Value	contains "W"	text	NO

Any help in setting this up would be appreciated.

Regards

Adam

 

[SquizzleKicks]

The top table is where I will be populating with the results and the bottom table is what I will be sharing with the team.