Team Name is repeated if it starts with a number

Attached is a spreadsheet used to track stats for teams in a tournament. On the STATS tab team names are shows in column A. They are pulled from the TEAMS tab. The formula I use came from someone on this forum a while back. In our last tournament we discovered that if the first team's name (on the TEAMS tab) starts with a number, then that name is repeated in all the locations on the STATS tab. If the name does not start with a number, it works as expected.
I am guessing it's a simple fix, but since I don't really understand how the formula works, I can't edit it.

Thoughts?

I would likely create a pivot table off the source data so it can aggregate the data for you, then a very simple index or lookup to grab the team names and such.
This way whenever the data is updated all you do is refresh the pivot and it flows through and THAT is easier for you to understand than a slick formula.

If you want to opt for a revised formula solution try this:

Formula:

=IF(MOD(ROW()-4,7)=1,INDEX(Teams!$A:$A,COUNTA(stats!$A$3:$A4)), "")

Let me know if you have any questions.

JeteMc - That appears to work. I'm going to play with it to make sure.


Thank you very much!!

You're Welcome and thank you for the feedback. If after testing it appears that the solution takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. I hope that you have a good day.