Results 1 to 5 of 5

How to generate non-repeating random numbers in a column wihtout VB

Threaded View

luv2glyd How to generate non-repeating... 02-14-2015, 07:33 PM
Brendan_Floyde Re: How to generate... 02-14-2015, 08:22 PM
MarvinP Re: How to generate... 02-14-2015, 09:17 PM
M E Good @ XL4M Re: How to generate... 02-15-2015, 12:51 AM
luv2glyd Re: How to generate... 02-16-2015, 12:43 AM
  1. 02-14-2015, 07:33 PM #1
    luv2glyd is offline
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Smile How to generate non-repeating random numbers in a column wihtout VB

    I have a column of 10 cells and would like to fill each cell with random numbers between 1 and 10 without any of these 10 numbers being generated more than once. Is that possible to do without VB?

    Thank you.
    Last edited by luv2glyd; 02-16-2015 at 12:43 AM.
    You either quit or become really good at it. There are no other choices.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generate Random Number for an Unknown Number of Numbers under a Cell Heading in Two Column
    By kewlgeye51 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-18-2013, 04:24 PM
  2. How to generate non-repeating random numbers
    By luv2glyd in forum Excel General
    Replies: 2
    Last Post: 09-24-2010, 12:16 PM
  3. I want random numbers generated without repeating
    By Johncobb45 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2006, 08:53 PM
  4. using excel generate random numbers 1 to 52 without repeating
    By Norman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2006, 02:25 AM
  5. How do I generate random, non-repeating numbers that don't change?
    By bsquared0 in forum Excel General
    Replies: 1
    Last Post: 07-30-2005, 12:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1