I'm trying to generate 100x bingo cards. I have 75 total "numbers" and each card is 5x5. Currently to generate each individual cell I'm doing the below formula, so this exists in all 2500 cells across the 100 cards;
=CHOOSE(RANDBETWEEN(1,75),Conditions!$A$2,Conditions!$A$3,Conditions!$A$4,Conditions!$A$5,Conditions!$A$6,Conditions!$A$7,Conditions!$A$8,Conditions!$A$9,Conditions!$A$10,Conditions!$A$11,Conditions!$A$12,Conditions!$A$13,Conditions!$A$14,Conditions!$A$15,Conditions!$A$16,Conditions!$A$17,Conditions!$A$18,Conditions!$A$19,Conditions!$A$20,Conditions!$A$21,Conditions!$A$22,Conditions!$A$23,Conditions!$A$24,Conditions!$A$25,Conditions!$A$26,Conditions!$A$27,Conditions!$A$28,Conditions!$A$29,Conditions!$A$30,Conditions!$A$31,Conditions!$A$32,Conditions!$A$33,Conditions!$A$34,Conditions!$A$35,Conditions!$A$36,Conditions!$A$37,Conditions!$A$38,Conditions!$A$39,Conditions!$A$40,Conditions!$A$41,Conditions!$A$42,Conditions!$A$43,Conditions!$A$44,Conditions!$A$45,Conditions!$A$46,Conditions!$A$47,Conditions!$A$48,Conditions!$A$49,Conditions!$A$50,Conditions!$A$51,Conditions!$A$52,Conditions!$A$53,Conditions!$A$54,Conditions!$A$55,Conditions!$A$56,Conditions!$A$57,Conditions!$A$58,Conditions!$A$59,Conditions!$A$60,Conditions!$A$61,Conditions!$A$62,Conditions!$A$63,Conditions!$A$64,Conditions!$A$65,Conditions!$A$66,Conditions!$A$67,Conditions!$A$68,Conditions!$A$69,Conditions!$A$70,Conditions!$A$71,Conditions!$A$72,Conditions!$A$73,Conditions!$A$74,Conditions!$A$75,Conditions!$A$76)
My issue is that sometimes a card has multiple instances of the same number as duplicates are not being weeded out. I need every value within a single 5x5 card to be unique I'm trying to avoid the attached example from happening.
I'm not trying to do a strict bingo card where the first column is 1-15, etc, as the numbers will be replaced with words eventually.
Alternatively if there is a way easier way to be doing this, that's be great, too :D!
Thanks!
Bookmarks