random generation

  1. T

    Problem with Index/Array and Random Number Generator

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

    Random List of Numbers

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

    Random wait time in application.wait VBA

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

    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!
  5. S

    Generating Random Grades With Correlation

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

    Assign a random name to 1000 vehicles

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

    Formula to create a random function with multiple outputs

    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!
  8. O

    Generate 'sample' data from data tables without duplicating some values and by having a clear order and relation between some of the sample values

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

    How to Create list of random numbers which gives specific total value?

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

    Selecting 3% of random numbers

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

    Checking for Multiple Conditions, Randomly Assigning Variable if True

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

    Create a schedule for golf - 12 players, 3 x 4 each day over 5 days. Minimum number of repeat players

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

    Random sampling macro sometimes pulls header row

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

    How do I set up a random name generator in excel

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

    Random number generation help needed urgently

    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!
  16. bobsan42

    [Example Code] Generate Unique Random Integers in a range of values

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

    RAND() and permanently capturing the results

    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"...
  18. khawarameer

    Random Selection in Excel

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

    Randomizer

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

    Random Selections Query

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top