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