Summary tab only displays totals for the first 39 unique entries . Need 70

[brisky]

We have a group of 60 golfers with 20 or so playing twice a week. We want everyone to play with as many different people as possible so we manually keep track of who played together and then manually pick teams each week based on who has played together the least.

I have a spreadsheet (attached) that keeps track of how many times each player has played with every other player. Tab 1 is the detail (tournament date and players in each group). However there are 2 problems:

1. Tab 2 (summary) only keeps track of the first 39 players from Tab 1.

2. Tab 2 (summary) is not in alphabetical order to make it easy to look up players. If item 1 is fixed I have a work around to get the summary tab in alphabetical order by entering the roster alphabetically under the first date and have them all play in the same group.

Any help is greatly appreciated.

Thank you!

 

[Nebu]

Hi:

I am not sure about the problem here can't you add the additional names and drag the formula across?

Thanks

 

[Chihiro]

You need to extend Named Ranges if you are adding more games/names to players sheet.

See attached.