A bit lengthy, but I believe this will give you the latest streak. Assuming
you put the formula into row 31, and your table goes to column G:

=COUNTA(OFFSET(B1,SUMPRODUCT(MAX(ROW(B2:B30)*(B2:B 30<VLOOKUP(99999,$A$2:$G$30,COLUMN()))*(B2:B30<" "))),):B30)&" "&VLOOKUP(99999,$A$2:$G$30,COLUMN())
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Renan Germano" wrote:

Let?s say one teams current form is: wwwddll
With this formula, the result is: 3 wins 2 draws 2 losses

But what I want it to say it?s just the latest streak.. in this example it would be 2 losses.
And if this team wins the next game, it sould change the result to 1 win..

Regards,
RG



Stefi wrote:

=COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&"
15-Jan-10

=COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&" losses,
"&COUNTIF(B2:B4,"d")&" draws"

--
Regards!
Stefi



???Renan Germano??? ezt ??rta:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# : Get and set the file and Directory attributes
http://www.eggheadcafe.com/tutorials...-the-file.aspx
.