Cutter,

I tinkered with the sheet you posted, and it all appears to work with one exception. The current streak seemed to start over after a by week. I noticed this on Atlanta when the win streak was 1 prior to the by week and 1 after the by week and both were wins.

I adjusted the formula starting on F80 to the following:
=IF(AND(F72<>"BY Week",F74=""),"",IF(F72="BY Week",E80,IF(OR(AND(E72="BY Week",F79<>""),F79=E79),E80+1,1))) to account for the week following a BY Week.

Other than this, everything else appears to work great.

Thanks again for all your help!