Results 1 to 2 of 2

Generate non-repeating random Double-Digit numbers

Threaded View

  1. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,054

    Re: Generate non-repeating random Double-Digit numbers

    Well, I think I may have solved it myself, two different ways. See attached.
    1) I put in a list of Static Values for the range, and put in a column of RAND() numbers. If I sort by my random numbers I get a random list of my range numbers.
    2) Using Anastasiya Romanova's comment at https://www.excelcampus.com/tips/lis...no-duplicates/
    I use my RAND() list and an Index/Match combo to generate the sequence numbers. Easy pizzi.

    Any other ways to do this, maybe without using the RAND() column?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 22
    Last Post: 06-27-2024, 10:35 AM
  2. Replies: 3
    Last Post: 11-26-2017, 08:58 AM
  3. [SOLVED] How to generate non-repeating random numbers in a column wihtout VB
    By luv2glyd in forum Excel General
    Replies: 4
    Last Post: 02-16-2015, 12:43 AM
  4. [SOLVED] VBA to generate random 5-digit serial numbers using
    By emymeeky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2014, 03:34 PM
  5. How to generate non-repeating random numbers
    By luv2glyd in forum Excel General
    Replies: 2
    Last Post: 09-24-2010, 12:16 PM
  6. 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
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1