CURRENT Win/Loss Streak

I have searched through past posts and a common question is the longest winning streak using rows of values in a column. My question (actually three parts) is almost the opposite.

I am building an NFL tracker to use in making picks on who will win or lose for an office pool. A few pieces of data I would like to create are the CURRENT streaks. These can be wins or losses, just want it to be current. In addition to a general display of thecurrent streak, I would like to show the current streak at home or away (3 streaks displayed in all).

I have a tab with a summary of each teams season, being fed from a stats page. The summary will update weekly as games are played.

As an example, line 72 shows if the games are" at" (away) or" hosted" (home) spanning from E72 to U72. Line 73 would show the opponent. Line 74 are the points for the team being summarized, and 75 are the points allowed (opponents score). I have on line 78 a" win" or "loss" for that game.

I would like to display on line 78 the current win/loss streak, 79 the streak at home" hosted", and line 80 the streak away" at". Columns E thru U can be used as an engine with a punch line displayed in column B78, B79 and B80.

Additional lines can be added for further engine formulas if needed. Any help is greatly appreciated. Once again it is the CURRENT streak and can be either winning or losing.

Thanks again.