random generation

I am trying to build into my spreadsheet a way to have a list of values in column D. For some reason, the code in each of the G pulls random values from column D but only for cell D19 and after. It never returns any values from cells D10-D18. What am I doing wrong in my code? <tbody>...

I am trying to generate a sequence of incremented integers where some are known and some are populated randomly within a sequence construct. For example: #<10<#<#<20<#<#<30<<<100 <#<#<1010, etc. The idea is that each of the "#" is replaced with a unique integer that is greater than the...

Hello everyone, hoping you could help me out. Currently I have a line of code in a macro: Application.Wait (Now + TimeValue("00:04:00")) In this example the application will pause for 4 minutes. I was wondering what I would have to do to randomize that time value, say anywhere from 1 to 10...

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!

I want to generate random grades for 30 hypothetical students in 3 courses, Math, Chem, and English. I can supply a mean and standard deviation and use NORM.INV and RAND() to compute a random grade in each subject for each student. What I can’t figure out is how to make the grades for each...

Hello, I have a list of 1000 vehicles with VIN numbers in column A. I would like to assign each VIN a random name from the following names available: <tbody> Winter Motor Company ALL PRO MOTORS AMERICAS AUTO AUCTION Dallas Auto Auction MANHEIM DALLAS FORT WORTH MANHEIM MINNEAPOLIS...

I would like to create a function that returns the following: 1. 20% of the time it returns a value of 0 2. 80% of the time it returns a normal distribution with a mean of 0.4, stdev of 0.1 but never less than 0 or more than 1. Please help!

So, I have a pretty specific thing to do that is rather hard to explain in the title but I hope it gives a general idea. Now, on to what I actually would like to be able to do and I'm not sure what is the best way to tackle it: * have a set of data tables that are something like: A - 100...

How to get specific total as sum of randomly(using randbetween/rand()) generated values? I always want to get specific value as the sum of randomly generated values For example I have sheet as shown below. <tbody> A B 1 =RANDBETWEEN(5,10)→ 5 2 =RANDBETWEEN(5,10)→ 6 3...

I am attempting to build an employee attrition model to better understand the impact on an organization. In my worksheet are the following data: column A: employee name, column B: job title, column C: random number and column D: identification of the attrited employees. In column C, I have...

Hello All, I have what I think may be a "simple" IF statement function, but I'm having trouble ensuring the "variable" can be randomaly assigned" to a category (depending on the results of the IF statement). So if you take a look below I'll try to explain. I have a set of survey...

I'm trying to create a 5 day golfing schedule for 12 players - this means there are 60 cells to fill. I want everyone to play with each other once but then have the minimum of repeats. I've tried the MRAND with INDEX which is great for each day's play but then find there are a lot of repeat...

I am using some VBA macro code I found on this very board and then modified to fit my needs. I want it to pull random samplings of rows from a very long list (i.e. random 15% from 4000 rows). The macro is triggered by a button and is used across ~10 sheets in this particular workbook. I am...

I need a formula that generates random names that i have in column a (a2:a30) I need the name to be in b1 to j1 there can't be any duplicate names

Hi, Im trying to generate random scores for about 200 students for 10 courses. Each student is only allowed to do 5 courses. Please any help with how to do this using excel vba? Thanks in advance!

it started with a question: http://www.mrexcel.com/forum/showthread.php?t=488078 in short the question was: numbers 1 to 90 ->random list with 30 of them. then i was really tempted to make a generic solution and i think i did. Below is a UDF which will generate random integer numbers within...

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags"...

Hello, I want to have an excel sheet which selects 32 names from given 60 names randomly and then arrange these 32 names into 8 groups of 4 each. can any one help me? Thanks

Is there a way to use a randomizer for values not numbers - for example: I have two columns A________B 1 Dog______ Dog 2 Cat_____(blank) 3(blank)___ Wolf 4 Sheep___(blank) I want a randomizer to only choose values for rows 1,2,4 in column A or if I run the randomizer in column b to only...

Hi, I have been tasked with creating a tool that will randomly select 'x' amount from a list of entries and distribute to 3 named persons over a 5 day week. Basically we have 75 servers that each need to be checked once a week (5 days) by any member of a team of 3. Therefore 15 servers per...