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 there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel shuffle?

  • 08-12-2005 8: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: 94,360 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