Index match -more than one answer?

[methody]

Hi
I have a grid with teams along the top row then rows for each week of the season.
In each row 1's and 0's are used to indicate if a team is playing. 1 means playing. 0 means not playing.

Normally there is only one team who is not playing (a bye). In the cells to the right of each row I want to enter the name of the team who is not playing. I am using Index match INDEX(GV$2:HL3,1,MATCH(0,GV3:HL3,0))

This is fine and does exactly what I want if there is only 1 team which is not playing but sometimes there can be up to 8 teams who have the week off. How can these all be entered in adjacent cell to the right of the grid.

Any help appreciated.

 

[jasonb75]

Perhaps you could try

=FILTER($GV$2:$HL$2,GV3:HL3=0,"")

 

[methody]

That's perfect. thank you