+ Reply to Thread
Results 1 to 3 of 3

Random Generating list

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    Random Generating list

    Trying to create a QC Random Generating List based on the "sample size p/m" for each "Type Service". The month is based on a 22 day month, not a 30 day. I would like for it to to meet or exceed the "Sample size p/m"

    QC Random Gen List sample.xlsx

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Random Generating list

    Where do you want this random generating list? A separate sheet? How long do you want the list to be? (once per workday?) For each day, do you want a random number for Type 1, Type 2, etc? Do you have a maximum value for these samples. For example Sample size for Type 1 (column M) is 8. So you want to randomly generate a list (I think for 22 days) with 8 as a minimum? Are numbers allowed to repeat or do they all need to be unique?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    SOLVED: Random Generating list

    Issue solved by qc program being purchased

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Generating a list with random units per sale from a list with the totals
    By Juliana33 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-05-2015, 03:45 AM
  2. Generating random cells from a list
    By Le_Kev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 04:27 AM
  3. Generating Random Numbers
    By darkblueblood in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2014, 03:10 AM
  4. Generating a list of Random numbers of random length...
    By Growl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 12:10 PM
  5. Generating a Random Number of Random Numbers
    By Garrus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2010, 09:39 AM
  6. generating random number list?
    By planetizzie in forum Excel General
    Replies: 10
    Last Post: 10-21-2009, 11:45 AM
  7. generating a whole random # from a list
    By Arturo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1