Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back a page or two to re-sync the thread and this will then show latest posts. Thanks, Mike.

Excel shuffle?

  • 08-12-2005 9:32pm
    #1
    Pigman II
    Closed Accounts Posts: 10,921 ✭✭✭✭


    I have the numbers :

    1 2 3
    4 5 6
    7 8 9

    in cells A1 to C3 of an excel sheet.

    Is there any function/trick that can be done to shuffle those numbers randomly to create another nine cells with aforementioned numbers in a new arrangement

    eg

    4 7 2
    1 9 3
    8 6 5

    etc

    I'll want to eventually use this on a set of around 64 cells.
    All help gratefully recieved.


Comments

  • #2
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 92,385 Mod ✭✭✭✭Capt'n Midnight


    Try some random numbers in adjacent cells and sort by the random numbers
    data sort will rejig the square

    You could probably automate with hlookup / vlookup or a bit of VB


  • #3
    Pigman II
    Closed Accounts Posts: 10,921 ✭✭✭✭Pigman II


    That worked well. Thanks for that Capt'.


Advertisement