bingo cards with song titles please try:This formula creates 50 random bingo cards with song titles. This formula assumes there are 80 different songs and 25 songs on each bingo card.Formula:
=LET(n,50,songs,K1:K80,x,ROWS(songs),IFNA(DROP(REDUCE("",SEQUENCE(n),LAMBDA(i,s,VSTACK(i,WRAPROWS(TAKE(SORTBY(songs,RANDARRAY(x)),25),5),""))),1),""))
If you want the same songs on each bingo card in a random order on each bingo card, please replace K1:K80 with K1:K25.
Bookmarks