Hi, I have created three sheets, 1 with student names, 1 with 12 week scores and 1 that will add later on with their current scores. I have attached images in terms of the issues I am having laying this out.
I selected one team and this works perfectly, the problem happens when I have teams that don't have the same amount of students or have too many..
Attached images which will describe the issue I am having. I thought I could join the agent name and 12 week scores but will have the same problem with the current score appearing in the right lines..
Thanks in advance.
well, it looks like your design is not really as it should be .. could you please post the example datasource ?