Resolved >>> Number of consecutive first values

Hi,

I'm writing a little excel file to help me with my betting. Basically I want to calculate each team's home winning/drawing/losing streak.

Here is a sample of the table (I've simplified it a bit and added fictional results):

(See Attached)

So, I want a formula that can tell me a given team's (e.g. Arsenal's) latest result, and how many previous consecutive results of that kind there have been. For example, for Arsenal, the result would be something like "W2" (i.e. Won the last two games).

At the moment, the best I can do is to get the TOTAL NUMBER of a given team's latest result using this formula:

=LOOKUP("ARS",B:B,C:C)&SUMPRODUCT(--(B1:B13="ARS")*(C1:C13=LOOKUP("ARS",B:B,C:C)))

(Which also returns "W2").

I'm sooooooo close, can someone please help!!

As an added bonus, could anyone help me in writing a formula that would express a given team's last 5 (or last n) results in the format "WWLDW" or "LLDDW"?