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

--
Message posted from http://www.ExcelForum.com