Results 1 to 7 of 7

Printing with new random sequence each time

Threaded View

  1. #6
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Printing with new random sequence each time

    bingo cards with song titles please try:
    Formula: copy to clipboard
    =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),""))
    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.

    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.
    Attached Files Attached Files
    Last edited by HansDouwe; 10-31-2023 at 01:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Random Column In sequence
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2020, 04:08 AM
  2. [SOLVED] Random Sequence?
    By mhnhcs in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 10-23-2018, 09:03 AM
  3. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  4. printing random pages with page numbers still in sequence
    By steve111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2014, 02:10 PM
  5. Random number sequence
    By tghcogo in forum Excel General
    Replies: 3
    Last Post: 04-10-2007, 04:25 PM
  6. [SOLVED] I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS
    By XLSUSER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2005, 06:10 AM
  7. Random Sequence with no Duplication
    By nebb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2005, 04:05 PM

Tags for this Thread

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