Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with vba
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 |