+ Reply to Thread
Results 1 to 3 of 3

Create A Random List of number 0 and 1

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    napoli
    MS-Off Ver
    EXCEL 2016
    Posts
    2

    Create A Random List of number 0 and 1

    Good evening to everyone,
    There is a way (formulas or vba) to solve this problem i have:

    Within 100 spreadsheet cells, I have to generate randomly 100 0 or 1 numbers. But the number of zero generated must be 60% whereas instead of the numbers 1 that consiquently must be 40%

    Hope someone can help me to solve this problem.
    Thanks in advance for help.
    Regards
    Vincent

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,246

    Re: Create A Random List of number 0 and 1

    This is not randomly but sponsored "lottery" ...

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    napoli
    MS-Off Ver
    EXCEL 2016
    Posts
    2

    Re: Create A Random List of number 0 and 1

    i've solved using RAND() in a column behind list of numbers.
    Thanks the same.
    Regards
    Vincent

+ 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. Replies: 3
    Last Post: 11-22-2013, 05:06 PM
  2. Replies: 2
    Last Post: 08-01-2012, 01:24 PM
  3. Create random number when cell changes
    By Matt W in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2011, 06:00 PM
  4. Create random number from 3-10
    By maacmaac in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2009, 05:32 PM
  5. [SOLVED] Create a unique random number
    By Jack in forum Excel General
    Replies: 2
    Last Post: 04-19-2006, 04:20 PM
  6. Create a New Random Number Every 2 Seconds
    By gatesheadthunde in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2005, 05:15 PM
  7. Create Random Number Generator
    By Pascale in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-06-2005, 12:05 PM
  8. How do I find random number in list of random alpha? (Position is.
    By jlahealth-partners in forum Excel General
    Replies: 0
    Last Post: 02-08-2005, 02:06 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