Try this...

B2 = W
B3 = W
B4 = D
B5 = L
B6 = L
B7 = L

Array entered** :

=LOOKUP(1E100,FREQUENCY(IF(B2:B7=LOOKUP("zzz",B2:B 7),ROW(B2:B7)),IF(B2:B7<LOOKUP("zzz",B2:B7),ROW(B 2:B7))))&"
"&LOOKUP("zzz",B2:B7)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Result: 3 L

Note: this will not work if there are empty cells within the range.

--
Biff
Microsoft Excel MVP


<Renan Germano wrote in message ...
Hello! I have a table with the results of each team?s recent games. In
column A are the game dates, and in each other column is a team name
(B1,C1,D1..). In B2,C2,D2 I put the result for that game, either W, D or
L.
How can i make a formula that gives me the current streak for each team?
It should give me, for example, 2 wins, 2 losses or 3 draws..
Tks


Submitted via EggHeadCafe - Software Developer Portal of Choice
Scriptless ASP Progress Indicator
http://www.eggheadcafe.com/tutorials...rogress-i.aspx