# randomization

1. ### Workout Randomizer

Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...
2. ### Randomization Based Off a Set of Rules

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...
3. ### Randomization Based Off a Set of Rules

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...
4. ### Pick random city names from each risk category in excel

Hi, I am trying to pick random city names from a list of very large data in excel, each city has different categories. I want to pick 23 city names randomly (3 from extremely low risk, 4 from very low risk, 4 from low risk, 5 from moderate risk, 2 from highly moderate risk, 2 from high risk and...
5. ### Need to randomly combine numbers

Hello guys, I have 18 numbers (not from 1 to 18) which I need to randomly combine with each other in groups of 6. Will appreciate any help on that. Have a good one!
6. ### [VBA] Continuously Randomized Data set gives Performance Output, How can I make VBA Find a better Solution?

Hello, I have a basic VBA program which randomly selects data from a larger set into multiple smaller sets, then based on these smaller sets takes an average of the values and gives a performance rating. As of now I can make a simple Do While loop that will continuously run the randomization...
7. ### Controlling randomization without VBA?

Greetings, Currently, I have a spreadsheet of text data that I need random blocks of. I have managed to take the data from the source column and arrange it "randomly" over five columns, but it isn't quite random. For example, the first row only contains values from the first row of the source...
8. ### IF Function with some randomization!!!

This is my function =if(A1=1,"+",if(A1=2,"-")), this function would be in cell B2. Now the problem is if A1 is neither 1 or 2 then FALSE appears in cell B2. so how do i fix it so that FALSE won't appear in cell B2 if neither 1 or 2 is in cell A1. Also in that same function I would like to add...
9. ### Generate random numbers with multiple conditional statements?

Help (Please!), I'm trying to randomly generate thirteen "Distractors" (single-digit numerals ranging from 2 to 8). However, the randomization must be subject to the condition that each new Distractor ("i") has not appeared as one of the previous three distractors (that is "i - 1", "i -...
10. ### Random ThemeColor in sub

In Excel 2007 VBA: Is it possible to randomize ThemeColor in a sub? I have a sub that formats cells that correspond to a certain named range. (here "SV") What I want is to randomize the ThemeColorAccent number in the code below. I have 3 more equivalent subs for other named ranges, and I...
11. ### Biblical verses with each letter of your name

:confused:This is a church project I have 26 alphabetic tables each containing a different number of records but all of the 26 alphabetic tables consist of the same columns: Column 1 the alphabet letter of that table (A, B, ......Z), Column 2 a verse from the Bible starting with that letter...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back