Results 1 to 4 of 4

Scrambling rows of data while keeping some rows grouped to one another

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2011
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    9

    Scrambling rows of data while keeping some rows grouped to one another

    I am currently working a project that requires me to scramble data by rows. Here is an image to help with my explanation: http://i.imgur.com/vUyoe.jpg

    You will see [number][letter] columns (3B, 4A...) are paired with [number] columns directly to the right. So 3B can be subdivided into 3B - 1, 3B -2, and so on. Or, as you can see more fully, 4A can be subdivided from 1 - 8.

    What I am trying to do is randomize all the 1A's, 2A's, etc. but also keep them with their respective subdivisions.

    So for example: my randomization may end up producing 2A - 2, 4B - 8, 1A - 1, and so on. I am slightly familiar with the rand() function, but it doesn't seem to help me in this case.

    Thanks for the help!
    Last edited by tekeetakshak; 04-27-2011 at 04:12 PM.

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