Random numbers without duplication (5x5 grid)

[Darren_workforce]

Hello,

Yep it's for a US bingo card generator. The problem is we use images instead of numbers. So my 5x5 bingo grid would need to generate a random group of numbers across the 25 squares without any numbers duplicating. I've tried multiple formulas and the closest I've gotten to success is below. However, the numbers are still duplicating since I think each column (or row) is treated independently by the formula. The range of numbers has been anywhere from 30 - 50 but I am trying to randomize 75 images for our next event. Any suggestions would be greatly appreciated.

=INDEX(UNIQUE(RANDARRAY(1,5,1,75,TRUE)),SEQUENCE(5))

 

[Fluff]

How about

=WRAPCOLS(TAKE(SORTBY(SEQUENCE(75),RANDARRAY(75)),25),5)

 

[Darren_workforce]

How about

=WRAPCOLS(TAKE(SORTBY(SEQUENCE(75),RANDARRAY(75)),25),5)

You came through again, Fluff!! Thank you very much for your help on this matter.

 

[Fluff]

You're welcome & thanks for the feedback.