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
--
Message posted from http://www.ExcelForum.com

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)

"belblanco " wrote in message
...
Hello all,

I'm fair with Excel but know nothing of VBA. I'm hoping someone will
help me to get started. I think I need a UDF to compute the Season
Win/Lose Streaks below. Weeks 1 through 3 are given and I've inserted
the correct W/L Streak answers so as to describe the problem... but I
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 3

Attachment filename: bjl test wl.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=593251
---
Message posted from http://www.ExcelForum.com/