More fishing excel help needed please guys

[philaltimas]

so i have this workbook that added up the league points
I put new members on to interim and they get added to the match day sheets
when I put the results in I see on the interim they have weights and points but on the summary, the names stop being added at row 40 , but I may have up to 250 members
where have i gone wrong

thanks for any help in advance..

[TMS]

You have formulae in each of the columns:

=INDEX(INTERIM!$I$2:$I$41,MATCH(Summary!$D5,INTERIM!$L$2:$L$41,0))&""

=IF(B5="","",ROWS($1:1))

=IFERROR(LARGE(IF(@INTERIM!$L$2:$L$41>0,INTERIM!$L$2:$L$41),ROWS($1:1)),"")

=VLOOKUP($B5,INDIRECT("'"&INTERIM!$F$2&"'!A1:E100"),5,FALSE)

=VLOOKUP($B5,INDIRECT("'"&INTERIM!$G$2&"'!A1:E100"),5,FALSE)

=IFERROR(INT(INDEX(INTERIM!$J$2:$J$41,MATCH(Summary!$D5,INTERIM!$L$2:$L$41,0))/16),"")

Wherever the range on the INTERIM sheet is limited to 41 (rows), change that to a higher number. For example, 250.

So, you have: =INDEX(INTERIM!$I$2:$I$250,MATCH(Summary!$D5,INTERIM!$L$2:$L$250,0))&"" and copy down.

[Fluff13]

You seem to be missing a number of names. Clear all cells B5:D5 down & use this in B5 only

Please Login or Register  to view this content.

[JohnTopley]

Change ranges from 41 to 250 (or your likely max)

[TMS]

Thanks for the rep.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.