The file was created and is used in Excel 2003.

I am not against using VBA. I typically do use the built in fuctions provided by Excel to do my calculations, and despite some becoming rather cumbersome, I usually am able to fix any bugs that arise with them. If VBA is the only/best way to do what I am hoping to accomplish, I will just have to spend a little more time figuring out the code.

I have heard of the possibility of an 18 week season. Would that change up things terribly? I know it would take some work on my part to create additional space to accomodate the additional weeks, but it shouldn't affect the win/loss streak formula. Unless it greatly changes the formula, I would consider this another "when we get to it" situation.

Thanks for the quick responses.