List generation based on a Criteria

I'm developing a spreadsheet which automatically generate a list based on a certain criteria. I have partially done the work i want but have a little problem in optimizing the issue.

For reference i'm enclosing the spreadsheet with the data and requirement. Looking for a Solution.

Hi,

Not all that clear on what you're actually asking us for. As you indicated, it is fairly functional already. Could you try to explain what you need differently, hopefully it will provide a bit more clarity so we can help. What exactly are you trying to optimize?


Also, if you don't mind, I'll make some suggestions for formula changes.

1. This is just a conceptually simpler method to calculate which row that team starts on for the lower section.

PHP Code: 

D19: 1  
I19: 1
D20: =IF($C$17-A19<=0,"",D19+($C$17-A19))
I20: =IF($H$17-F19<=0,"",I19+($H$17-F19))
.... and copy them down. 


2. Where you determine the match number, I'd recommend replacing the locations where you put 28 with ROW($A$28) for the first section and ROW($F$28) for the second section. The reason for this change is it gives you more flexibility. You can add rows above this lower section (or remove rows) without needing to adjust the formulas). Leaving in the 28, you would need to change the formulas anytime you make a layout change.

PHP Code: 

A29: =IF(ROW()-ROW($A$28)<=COMBIN($D$2,2),ROW()-ROW($A$28),"")
F29: =IF(ROW()-ROW($F$28)<=COMBIN($I$2,2),ROW()-ROW($F$28),"")
.... and copy them down. 


Of course, it could just be me that doesn't understand. :-)
S