randomization

I have a 10x10 grid from A1:J10 and want to generate a 'x' in the cells in a random order, based off the below criteria, almost like a reverse COUNTA() function. - Each row and each column has 4 'x' in it. - The placement of those 'x' are random. Something similar to the below grid, but with...

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)...

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...

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...

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...

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!

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...

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...

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...

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 -...

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...

: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...