=COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&"
in [Functions]
|
From: Renan on 15 Jan 2010 09:27 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/aspnet/de7bc82c-7e09-47c2-bb21-e06f68ae2a41/c--get-and-set-the-file.aspx
From: Luke M on 15 Jan 2010 13:55
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:B30<>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/aspnet/de7bc82c-7e09-47c2-bb21-e06f68ae2a41/c--get-and-set-the-file.aspx > . > |