1. Nearly there!

Bernie thanks for all your help on this.

It's now pulling out 4 names if needed.Is there a way to hide the names at the beginning.
When the Spreadsheet is empty it's putting all the names in anyway and then changing them once the data in cells B-E are entered.

I ideally need column F blank so that when the points are entered it then populates the column F with the winning teams of the week, because otherwise the main Totals sheet has all the teams on for every week in advance (and that will just confuse the Head teacher)

I think I've managed to upload the spreadsheet so you can see what I'm trying to achieve.

Catherine

2. For Year 6, cell F3, array-enter using Ctrl-Shift-Enter:

=IF(COUNTA(B3:E3)=0,"",IFERROR(INDEX(\$2:\$2,SMALL(IF(\$B3:\$E3=MAX(\$B3:\$E3),COLUMN(\$B3:\$E3)),1)),"") & IFERROR(", " & INDEX(\$2:\$2,SMALL(IF(\$B3:\$E3=MAX(\$B3:\$E3),COLUMN(\$B3:\$E3)),2)),"") & IFERROR(", " & INDEX(\$2:\$2,SMALL(IF(\$B3:\$E3=MAX(\$B3:\$E3),COLUMN(\$B3:\$E3)),3)),"") & IFERROR(", " & INDEX(\$2:\$2,SMALL(IF(\$B3:\$E3=MAX(\$B3:\$E3),COLUMN(\$B3:\$E3)),4)),""))

3. Here is a completed version with the summary tab filled out.

4. OMG Bernie

I'm sitting here with tears. I didn't know that people like you still existed. You have saved me hours of work! I'm so very very grateful. I can now get on a do what I am good at, (teaching) without fretting that I haven't delivered. I'm going to look at what you've done and figure it out, so I can do it again and again.

5. I'm very happy to hear that my version does what you need. People like me exist all over these forums - I've been on the receiving end (and still am!) so I like to pay back those kindnesses. I especially like helping those who make contributions to their communities: teachers, firefighters, nurses and doctors....

Take care, and good luck with the new school year and the extra new challenges that all teachers are facing.

6. Sorry. Back again!
We started to use the Spreadsheet and it looks great but when its the 18th of anything it populates all the 18ths. Is there a way to not do this?

7. I changed how the lookup is done - this will just pull them in order of entry...

8. Thank you! That's perfect