Results 1 to 12 of 12

randbetween function - no duplicates in specific area?

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2017
    Location
    Illinois
    MS-Off Ver
    2013
    Posts
    12

    randbetween function - no duplicates in specific area?

    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!
    Attached Images Attached Images
    Last edited by SineNomine; 08-09-2020 at 01:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. RandBetween - No Duplicates in Column
    By stewarttracy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2018, 04:36 PM
  2. [SOLVED] Randbetween with No Duplicates
    By novice1239 in forum Excel General
    Replies: 6
    Last Post: 03-19-2017, 10:17 AM
  3. [SOLVED] Need help to move duplicates from a list and paste them in a specific area on worksheet
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-13-2015, 08:21 PM
  4. How do you avoid duplicates when using the randbetween function?
    By Monica in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2014, 02:07 AM
  5. Randbetween without duplicates
    By Williamdry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2014, 09:27 AM
  6. [SOLVED] =RANDBETWEEN Function for growing price list with no duplicates...
    By unclejemima in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 03:29 PM
  7. making a specific RANDBETWEEN function
    By cowboy713 in forum Excel General
    Replies: 4
    Last Post: 11-05-2010, 04:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1