Winning & Losing Streaks???

[asenk]

Hello....Thanks in advance for helping me out...

I've been trying for the last few days to figure out how to calucate winning streaks in excel. I've seen postings on this website that have been help from a broad perspective but I need more specific help. I have the current schedule of a fantasy football team and I want to calculate several things:

The longest winning and losing streak
The current streak "winning or losing"
The longest home winning and losing streak
The Longest away winning and losing streak
The longest division winning and losing streak
The longest non-division winning and losing streak

I've figured out how to calculate the longest winning and losting streak by using:
{=MAX(FREQUENCY(IF(I4:I19="Win",ROW(I4:I19)),IF(I4:I19<>"Win",ROW(I4:I19))))}
and I'm sure figureing the above out is using some varation or coninuation of that formula but I can't figure it out. please help me...

Also I have a attachment I can provide I'm just not sure how to attach to this post...

[TABLE="width: 855"]
<TBODY>[TR]
[TD="colspan: 10"]Philly Phanatics</SPAN>[/TD]
[TD][/TD]
[TD="colspan: 2"]Streak</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 10"]Owner: Andrew S</SPAN>[/TD]
[TD][/TD]
[TD]Current Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]Week</SPAN>[/TD]
[TD]H/A </SPAN>[/TD]
[TD]Opponent</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD]ND</SPAN>[/TD]
[TD]PF</SPAN>[/TD]
[TD]PA</SPAN>[/TD]
[TD]SM</SPAN>[/TD]
[TD]W/L</SPAN>[/TD]
[TD]Bench</SPAN>[/TD]
[TD][/TD]
[TD]Longest Winning Streak</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD] [/TD]
[TD]Terrific Tiffany's</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]279</SPAN>[/TD]
[TD]223</SPAN>[/TD]
[TD]56 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Longest Losing Streak</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]Boriqua Reds</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]209</SPAN>[/TD]
[TD]132</SPAN>[/TD]
[TD]77 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Home Winning Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD] [/TD]
[TD]Team Chesanek</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]169</SPAN>[/TD]
[TD]132</SPAN>[/TD]
[TD]37 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Home Losing Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD] [/TD]
[TD]Team Mussman</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]226</SPAN>[/TD]
[TD]192</SPAN>[/TD]
[TD]34 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Road Winning Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]CT CANTFWITIT</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]177</SPAN>[/TD]
[TD]127</SPAN>[/TD]
[TD]50 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Road Losing Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]6</SPAN>[/TD]
[TD] [/TD]
[TD]Terrific Tiffany's</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]223</SPAN>[/TD]
[TD]211</SPAN>[/TD]
[TD]12 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Division Winning Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]7</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]Boriqua Reds</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]216</SPAN>[/TD]
[TD]210</SPAN>[/TD]
[TD]6 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Division Losing Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]8</SPAN>[/TD]
[TD] [/TD]
[TD]Team Chesanek</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]229</SPAN>[/TD]
[TD]202</SPAN>[/TD]
[TD]27 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Non-Division Winning Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]9</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]Mussmanzadada…championship!</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]173</SPAN>[/TD]
[TD]231</SPAN>[/TD]
[TD](58)</SPAN>[/TD]
[TD]Loss[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD]Non-Division Losing Streak</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]10</SPAN>[/TD]
[TD] [/TD]
[TD]Drunk Polacks</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]181</SPAN>[/TD]
[TD]141</SPAN>[/TD]
[TD]40 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]Terrific Tiffany's</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]204</SPAN>[/TD]
[TD]178</SPAN>[/TD]
[TD]26 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12</SPAN>[/TD]
[TD] [/TD]
[TD]Boriqua Reds</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]258</SPAN>[/TD]
[TD]156</SPAN>[/TD]
[TD]102 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13</SPAN>[/TD]
[TD]@</SPAN>[/TD]
[TD]Team Chesanek</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]220</SPAN>[/TD]
[TD]154</SPAN>[/TD]
[TD]66 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pl Rd 1</SPAN>[/TD]
[TD] [/TD]
[TD]Team Chesanek</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD] [/TD]
[TD]226</SPAN>[/TD]
[TD]223</SPAN>[/TD]
[TD]3 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pl Rd 2</SPAN>[/TD]
[TD] [/TD]
[TD]Mussmanzadada…championship!</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]215</SPAN>[/TD]
[TD]136</SPAN>[/TD]
[TD]79 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pl Rd 3</SPAN>[/TD]
[TD] [/TD]
[TD]Team Mussman</SPAN>[/TD]
[TD] [/TD]
[TD]ND</SPAN>[/TD]
[TD]197</SPAN>[/TD]
[TD]169</SPAN>[/TD]
[TD]28 </SPAN>[/TD]
[TD]Win[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Totals</SPAN>[/TD]
[TD]10 </SPAN>[/TD]
[TD]6 </SPAN>[/TD]
[TD]3,402 </SPAN>[/TD]
[TD]2,817 </SPAN>[/TD]
[TD]585 </SPAN>[/TD]
[TD]15.0 </SPAN>[/TD]
[TD]N/A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]