I am having a problem constructing a golf scoring sheet that tracks
team skins with team rotation every 6 holes and provides for
carryovers across the 6 hole boundaries. I have a data entry array(#1)
for entering the scores for each of 4 players, an array(#2) for
calculating the winning team and returning a 1, or a 0 if it is a
carryover for each of the two teams. I have a third array(#3) to
reconcile the carryovers based on testing the 1 or 0 for each hole (in
array #2) and if 0 looking ahead until a 1 is found and returning a 1
for that cell. I can do this by nesting IF functions which test for a
0 or 1 for each team for each hole, however I encounter the 7 nesting
limit in Excel 2000.
I am wondering if this is something that can be practically achieved
in excel, or is a more robust language required which can call a
subroutine to evaluate the carryover cells.

Thank in advance,

Bill