shuffle

I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D). For example: Is possible to do that by using VBA or with some formula? Thanks for the help.

Hi, I have a VBA that will happily shuffle cells within a column, I am looking to expand on this and have it shuffle across rows of 2 also as I need it to create fixtures from a list on a regular basis, therefore I need Home and Away teams changing on a weekly basis. This is the current code I...

Hello all, I have this code that I use to randomize cell contents. So I can take the values of A1:A10 and rearrange the order randomly. My problem is, if in B1:B10 I have values that correspond to the values on Column A, they either don't shuffle, or they are included in the shuffle, but they...

Shuffle words to appear to be random Hi , I'm trying to make some data look a little more 'human' by shuffling around some words/phrases. Each cell will always contain 4 words/phrases. I'd like to shuffle them to make them look random. The comma needs to be the deliminator because sometimes...

Hi, I have 20 rows and 3 columns of numbers. In the description below please note that row repetition is allowed: (1) randomly pick one row from the original list and place it as the 1st row of a second 20-row list, (2) randomly pick one row from the original list and place it as the 2nd row...

Hello, Im trying to have a cell populate if conditions are met in 2 others cells (ive been using an If statement). I would like the cell that will populate to pull from a list of names and the results to evenly randomize or just choose from the next name on the list (and start from the...

I have a random set of numbers 1-100 in a column which I generated with =rankbetween() and shuffle with =rank(). How can I maintain a degree of random but create a degree of ascending order (ie. 2,8,1, 9,6,12,11...88,100,79)?

I have been using this great website for a while, but I finally came across something that has stumped me, and I haven't seen in other posts. So here is my first post. So I have code that 'works', but I feel like it could be better. (And to be usable, it has to be) My problem involves a large...

I have a spreadsheet filled with rows of different smartphone apps, a little over 300 rows of them. These smartphones are divided into about 10 or so categories (for instance: sports, finance, games, entertainment...). At present, each app category is in consecutive order in the spreadsheet - so...

How to scramble text. I have been trying to figure this out and i have had no luck. So far no one has been able to help me with this one. I will try to explain as best as possible. I have have a quiz that i am tying to make, with multiple questions. But i want to make as many possibilities as...

I am new to the site and I'm not a programmer. I don't know if this is possible or not, but I have a club membership list and a list of duties that need to be completed each meeting. Is there a formula or macros that I can use that will randomly shuffle the names and the duties every week so...

I'm trying to figure out a formula to shuffle data based on the what column category they're in. Any Column with a letter "A" will be "partnered up" with any of the names the are under any Column with a letter "B". The letter excel looks like this: When it shuffles, it'll look like this...