need help with vba

[belblanco]

Hello all,

I'm fair with Excel but know nothing of VBA. I'm hoping someone wil
help me to get started. I think I need a UDF to compute the Seaso
Win/Lose Streaks below. Weeks 1 through 3 are given and I've inserte
the correct W/L Streak answers so as to describe the problem... but
have no idea how to code it. Thanks for even looking at it.


Won Loss
Week 1 Team A 1
Team B 1

Team C 1
Team D 1

Week 2 Team A 1
Team C 1

Team B 1
Team D 1

Week 3 Team A 1
Team D 1

Team B 1
Team C 1

W-Streak L-Streak
Season Team A 1
Team B 1
Team C 3
Team D

Attachment filename: bjl test wl.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=59325

 

[Bob Phillips]

The link doesn't work.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)