Baseball system help W or L

[Marcusandkylie]

Hello,

Need help with this Baseball System, I need excel to automatically enter the W or L result based on the highest number in columns K or L, for example, Systems says New York (6.67) should beat Philadelphia (3.60) but New York lost and I manually entered L. I have faith someone here can crack this formula.

MLB TRIAL.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	AE	AF	AG
1																		CORRECT RECORD													REVERESED RECORD
2																		LEFT SIDE W/L						64	33	66.0				33	64	34.0
3																		RIGHT SIDE W/L						42	55	43.3				55	42	56.7
4
5																		OVER/UNDER					52	43	4	54.7
6																		HOME BOYS					68	31		68.7
7
8	DATE			VISITOR		HOME	TIME (ET)	MONEYLINE	MONEYLINE	O/U	SYSTEM A - VISITOR	SYSTEM A - HOME				A. SCORE	H. SCORE	COMBINED RUNS				GAME WINNER	GAME WINNER	SYSTEM B - VISITOR	SYSTEM B - HOME
9	2021-06-12	SAT	A	New York Y	N	Philadelphia	4:05 PM	-124	103	9	6.67	3.60	10.27		L	7	8	15	O			W		15.33	8.40	23.733		L	D		-124	-$ 620	-$ 1,240
10	2021-06-12	SAT	A	Kansas City	A	Oakland	4:07 PM	155	-190	9	3.00	3.56	6.56	W		2	11	13	O			W		16.00	3.44	19.444		L		F	-100	-$ 500	-$ 1,000
11	2021-06-12	SAT	A	Los Angeles A	N	Arizona	4:10 PM	-121	105	9	5.40	5.00	10.40	W		8	7	15	O				L	19.60	22.00	41.6		L	D		-100	-$ 500	-$ 1,000
12	2021-06-12	SAT	N	Atlanta	N	Miami	4:10 PM	-185	155	7.5	3.00	2.50	5.50		L	2	4	6		U		W		16.00	10.50	26.5		L	D		-185	-$ 925	-$ 1,850
13	2021-06-12	SAT	A	Baltimore	A	Tampa Bay	4:10 PM	190	-255	7.5	0.67	4.50	5.17	W		4	5	9	O			W		6.33	13.50	19.833	W			F	100	$ 500	$ 1,000
14	2021-06-12	SAT	A	Chicago W	A	Detroit	4:10 PM	-205	170	9	4.00	2.80	6.80	W		15	2	17	O				L	9.00	10.20	19.2		L	D		-100	-$ 500	-$ 1,000
15	2021-06-12	SAT	N	Colorado	N	Cincinnati	4:10 PM	145	-170	9	3.89	13.75	17.64	W		3	10	13	O			W		4.11	-0.75	3.3611		L		F	-100	-$ 500	-$ 1,000
16	2021-06-12	SAT	N	Pittsburgh	N	Milwaukee	4:10 PM	265	-325	7.5	2.67	5.25	7.92	W		4	7	11	O			W		4.33	7.75	12.083	W			F	100	$ 500	$ 1,000
17	2021-06-12	SAT	N	San Diego	N	New York M	4:10 PM	-140	115	7	1.11	2.63	3.74	W		1	4	5		U		W		4.89	9.38	14.264	W		D		115	$ 575	$ 1,150
18	2021-06-12	SAT	A	Seattle	A	Cleveland	4:10 PM	100	-120	8.5	0.00	12.25	12.25	W		4	5	9	O			W		7.00	10.75	17.75	W			F	100	$ 500	$ 1,000
19	2021-06-12	SAT	A	Toronto	A	Boston	4:10 PM	-105	-115	10	8.89	5.33	14.22	W		7	2	9		U			L	17.11	5.67	22.778	W			F	100	$ 500	$ 1,000
20	2021-06-12	SAT	A	Houston	A	Minnesota	7:15 PM	-130	110	9.5	0.67	2.67	3.33	W		2	5	7		U		W		13.33	4.33	17.667		L	D		-130	-$ 650	-$ 1,300
21	2021-06-12	SAT	N	San Francisco	N	Washington	2:05 PM	-174	145	6	0.44	0.00	0.44		L	0	2	2		U		W		3.56	4.00	7.5556	W		D		145	$ 725	$ 1,450
22	2021-06-12	SAT	N	San Francisco	N	Washington	7:15 PM	-120	100	7	0.00	1.33	1.33		L	2	1	3		U			L	8.00	4.67	12.667	W		D		100	$ 500	$ 1,000
23	2021-06-12	SAT	N	St. Louis	N	Chicago C	7:15 PM	160	-190	8.5	5.00	10.00	15.00	W		2	7	9	O			W		8.00	-3.00	5		L		F	-100	-$ 500	-$ 1,000
24	2021-06-12	SAT	A	Texas	N	Los Angeles D	10:10 PM	232	-281	7.5	0.44	24.00	24.44		L	12	1	13	O				L	18.56	-9.00	9.5556	W			F	232	$ 1,160	$ 2,320
25	2021-06-13	SUN	A	New York Y	N	Philadelphia	1:05 PM	110	-132	8.5	7.00	11.20	18.20	W		0	7	7		U		W		11.00	12.80	23.8	W			F	100	$ 500	$ 1,000
26	2021-06-13	SUN	N	San Francisco	N	Washington	1:05 PM	-108	-112	8.5	0.75	0.50	1.25		L	0	5	5		U		W		23.25	8.50	31.75		L		F	-108	-$ 540	-$ 1,080
27	2021-06-13	SUN	N	Atlanta	N	Miami	1:10 PM	108	-129	7.5	1.56	4.00	5.56		L	6	4	10	O				L	9.44	6.00	15.444	W			F	108	$ 540	$ 1,080
28	2021-06-13	SUN	A	Baltimore	A	Tampa Bay	1:10 PM	156	-187	8	2.67	5.63	8.29	W		1	7	8			P	W		5.33	17.38	22.708	W			F	100	$ 500	$ 1,000
29	2021-06-13	SUN	A	Chicago W	A	Detroit	1:10 PM	-227	189	9	21.67	1.11	22.78	W		4	1	5		U			L	5.33	13.89	19.222		L	D		-100	-$ 500	-$ 1,000
30	2021-06-13	SUN	N	Colorado	N	Cincinnati	1:10 PM	136	-164	9.5	2.33	17.50	19.83	W		2	6	8		U		W		9.67	3.50	13.167		L		F	-100	-$ 500	-$ 1,000
31	2021-06-13	SUN	N	San Diego	N	New York M	1:10 PM	-132	110	8	0.67	2.50	3.17		L	7	3	10	O				L	9.33	4.50	13.833	W		D		100	$ 500	$ 1,000
32	2021-06-13	SUN	A	Seattle	A	Cleveland	1:10 PM	202	-243	7.5	3.20	4.00	7.20		L	6	2	8	O				L	22.80	12.00	34.8	W			F	202	$ 1,010	$ 2,020
33	2021-06-13	SUN	A	Toronto	A	Boston	1:10 PM	-133	111	10	7.78	1.11	8.89	W		18	4	22	O				L	3.22	12.89	16.111		L	D		-100	-$ 500	-$ 1,000
34	2021-06-13	SUN	A	Houston	A	Minnesota	2:10 PM	-180	145	9.5	1.11	5.00	6.11		L	14	3	17	O				L	5.89	10.00	15.889		L	D		-100	-$ 500	-$ 1,000
35	2021-06-13	SUN	N	Pittsburgh	N	Milwaukee	2:10 PM	156	-187	8.5	4.44	7.00	11.44	W		2	5	7		U		W		18.56	5.00	23.556		L		F	-100	-$ 500	-$ 1,000
36	2021-06-13	SUN	A	Kansas City	A	Oakland	4:07 PM	173	-208	8.5	1.11	19.25	20.36	W		3	6	9	O			W		14.89	-2.25	12.639		L		F	-100	-$ 500	-$ 1,000
37	2021-06-13	SUN	A	Los Angeles A	N	Arizona	4:10 PM	-137	114	9.5	10.67	7.78	18.44	W		10	3	13	O				L	8.33	-0.78	7.5556	W		D		100	$ 500	$ 1,000
38	2021-06-13	SUN	A	Texas	N	Los Angeles D	4:10 PM	195	-235	8	22.67	0.67	23.33		L	3	5	8			P	W		-7.67	11.33	3.6667	W			F	100	$ 500	$ 1,000
39	2021-06-13	SUN	N	St. Louis	N	Chicago C	7:00 PM	109	-131	9.5	1.11	4.38	5.49	W		0	2	2		U		W		13.89	8.63	22.514		L		F	-100	-$ 500	-$ 1,000
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
Y8	Cell Value	between 8.01 and 3.888	text	NO
X8	Cell Value	between 8.01 and 3.888	text	NO
L8	Cell Value	between 8.01 and 3.888	text	NO
Y7,K8:K21	Cell Value	between 8.01 and 3.888	text	NO
L22	Other Type	Icon set		NO
Z22	Other Type	Icon set		NO
X22	Other Type	Icon set		NO
I1:I4,I7	Other Type	Icon set		NO
Z1,Z4,Z7	Other Type	Icon set		NO
K1:K4,K7	Other Type	Icon set		NO
Z8,AP1:AP7	Other Type	Icon set		NO
I6	Other Type	Icon set		NO
K6	Other Type	Icon set		NO
Y22	Cell Value	between #REF! and #REF!	text	NO
Y22	Other Type	Color scale		NO
K22	Cell Value	between 8.01 and 3.888	text	NO
Q6	Cell Value	between 4 and 5	text	NO
Q1:Q4,Q7	Cell Value	between 4 and 5	text	NO
F1:F3,F6:F92	Cell Value	contains "Cleveland"	text	NO
F1:F3,F6:F92	Cell Value	contains "Washington"	text	NO
F1:F3,F6:F92	Cell Value	contains "Colorado"	text	NO
F1:F3,F6:F92	Cell Value	contains "Arizona"	text	NO
F1:F3,F6:F92	Cell Value	contains "Texas"	text	NO
F1:F3,F6:F92	Cell Value	contains "Boston"	text	NO
F1:F3,F6:F92	Cell Value	contains "Minnesota"	text	NO
F1:F3,F6:F92	Cell Value	contains "Philadelphia"	text	NO
F1:F3,F6:F92	Cell Value	contains "New York M"	text	NO
F1:F3,F6:F92	Cell Value	contains "San Francisco"	text	NO
F1:F3,F6:F92	Cell Value	contains "Los Angeles D"	text	NO
F1:F3,F6:F92	Cell Value	contains "San Diego"	text	NO
F1:F3,F6:F92	Cell Value	contains "Miami"	text	NO
Y23:Y92,AO1:AO7,Y9:Y21	Cell Value	between #REF! and #REF!	text	NO
Y23:Y92,AO1:AO7,Y9:Y21	Other Type	Color scale		NO
AF3	Cell Value	between 8.01 and 3.888	text	NO
AE2	Cell Value	between 8.01 and 3.888	text	NO
AF2	Cell Value	between 8.01 and 3.888	text	NO
AD3	Cell Value	between 8.01 and 3.888	text	NO
Y3	Cell Value	between 8.01 and 3.888	text	NO
Z3	Cell Value	between 8.01 and 3.888	text	NO
X2	Cell Value	between 8.01 and 3.888	text	NO
Z2	Cell Value	between 8.01 and 3.888	text	NO
Y1,Y4,K23:K92	Cell Value	between 8.01 and 3.888	text	NO
X23:X92,X9:X21	Other Type	Icon set		NO
Z23:Z92,Z9:Z21	Other Type	Icon set		NO
L23:L92,L9:L21	Other Type	Icon set		NO

 

[Fluff]

Another option for col N

=IF(OR(AND(K9>L9,P9>Q9),AND(K9<L9,P9<Q9),AND(K9=L9,P9=Q9)),"W","")

 

[antman2988]

Another option for col N

=IF(OR(AND(K9>L9,P9>Q9),AND(K9<L9,P9<Q9),AND(K9=L9,P9=Q9)),"W","")

IDK why, but I tried testing something similar but wasn't getting the expected results. Thanks for pointing out a simple solution, Fluff.

 

[Marcusandkylie]

thanks man it worked

 

[Marcusandkylie]

Appreciate all the help, I have another problem I need help with the same sheet. Should I post it in a new thread or here?

 

[antman2988]

Appreciate all the help, I have another problem I need help with the same sheet. Should I post it in a new thread or here?

You should definitely post it in a new thread so others who have the same issue will be able to gain knowledge/assistance from it. You've accepted a solution for the above issue so this thread has been resolved.

 

[antman2988]

Appreciate all the help, I have another problem I need help with the same sheet. Should I post it in a new thread or here?

You've already accepted a solution so this thread has been resolved now.

IDK why, but I tried testing something similar but wasn't getting the expected results. Thanks for pointing out a simple solution, Fluff.

I figured out the issue was with a macro of mine changing my formulas to manual....

 

[Fluff]

thanks man it worked

Glad we could help & thanks for the feedback.