+ Reply to Thread
Results 1 to 10 of 10

Shuffling cells

  1. #1
    Registered User
    Join Date
    06-16-2012
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    58

    Shuffling cells

    I have a page (or two..) with 300 cells of words, no numbers.
    I need to shuffle the order of the entire collection so that I can print out a different order every time; let's say 3 columns a page until I have inserted all the words.

    I did try numerous searches but all I come up is the RAND function thingy; I don't want number appearing on my printouts, I need the words with enough space after to enter comments.

    Either Word or Excel or anything else would work.
    Thanks.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Shuffling cells

    Use the RAND thingy and don't include the RAND thingy column in the print range.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-16-2012
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    58

    Re: Shuffling cells

    That's it then, no other way?

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Shuffling cells

    There are a hundred ways to do it, but you haven't provided any information about why the simplest approach is not well suited to your problem, or described your workbook layout in sufficient detail to suggest an alternative.

    Posting a workbook with some additional explanation might invite other ideas.
    Last edited by shg; 08-19-2012 at 04:00 PM.

  5. #5
    Registered User
    Join Date
    06-16-2012
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    58

    Re: Shuffling cells

    shg,
    I have worked it out in the included manner, it's a list of airport identifiers so that the user can randomize, printout and memorize them; there's enough space next to each identifier to enter decode the 4 letter ICAO code or encode the city, depending on what is presented.
    The two columns here are individually randomized but I was hoping to have both columns inter-mixed and randomized as a whole.

    This is as good as it can get is what I gather, aside from the fact that I can't interchange the two columns, the only other issue is that when I print the list out, I have to make sure the page breaks are good.

    ICAOfull.xls
    Last edited by MrBurns; 08-19-2012 at 10:41 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Shuffling cells

    Just some thoughts ..
    Think what you are currently using is IMO, a simple, effective way to randomize

    As for this line ..
    > .. I was hoping to have both columns inter-mixed and randomized as a whole
    You could stack the 2 col source lists up into a single col range, then randomize this range into another col (in the way you're doing it right now), then split it into 2 cols as the final output

    To split a single col into 2 (zig-zag style*),
    you could use something like this
    Assuming your single col data runs in J1 down
    Put in K1: =OFFSET($J$1,COLUMNS($A:A)-1+ROWS($1:1)*2-2,)
    Copy to L1, fill down as far as required to exhaust the extracts

    *Eg
    Source data
    1
    2
    3
    4
    etc

    Into Zig-zag output
    1 - 2
    3 - 4
    etc

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Shuffling cells

    Perhaps as attached.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    06-16-2012
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    58

    Re: Shuffling cells

    Quote Originally Posted by shg View Post
    Perhaps as attached.
    Not entirely sure how you did that but it looks great! Thanks! If you could give an explanation in case I want to make font size changes, it would be appreciated..

    Max, Thanks for your input as well, I tried to get it to function last night but couldn't, probably some parameter I got wrong or was too tired...
    Last edited by MrBurns; 08-20-2012 at 04:57 PM.

  9. #9
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Shuffling cells

    > .. Max, Thanks for your input as well, I tried to get it to function last night but couldn't, probably some parameter I got wrong or was too tired

    No worries. If you're happy with what shg has provided you, then that's best. Should you wish to pursue my inputs (it should work as well for you as it did for me) please continue to ask, let me know how you tried it out.

  10. #10
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Shuffling cells

    If you could give an explanation in case I want to make font size changes, it would be appreciated..
    That's pretty cryptic, MB, which is not in the nature of the pilots I know, including YT.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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