+ Reply to Thread
Results 1 to 6 of 6

generate n random numbers not duplicated for each id numbers with Vba

  1. #1
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    36

    Question generate n random numbers not duplicated for each id numbers with Vba

    Hi
    I want to generate random numbers not duplicated for each same Auction_ID , I have more than 1000 rows and more than 100 Auction_ID, my condition is if the Auction_ID is equal with next Auction_ID generate random numbers not duplicated, its ok if i see duplicated numbers in different Auction_id, but it must be unique for equal Auction_id ..any idea for that?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by fatoom91; 12-21-2019 at 02:51 PM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Hi,

    easier to understand with an attachment for the before workbook (raw data) and the after workbook (expected result) …

  3. #3
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    36

    Re: generate n random numbers not duplicated for each id numbers with Vba

    Quote Originally Posted by Marc L View Post
    Hi,

    easier to understand with an attachment for the before workbook (raw data) and the after workbook (expected result) …
    Thank u for your answer, I upload file , sheet1 is the output of the code and sheet2 (expected result)

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: generate n random numbers not duplicated for each id numbers with Vba

    How about
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-20-2019
    Location
    lebanon
    MS-Off Ver
    2016
    Posts
    36

    Re: generate n random numbers not duplicated for each id numbers with Vba

    Quote Originally Posted by Fluff13 View Post
    How about
    Please Login or Register  to view this content.
    thanks alot!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: generate n random numbers not duplicated for each id numbers with Vba

    You're welcome

+ 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] generate random numbers between 1 to 10 vba rnd()
    By ihrktho in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2014, 09:51 AM
  2. Generate Random Numbers Between 0-9
    By dreicer_Jarr in forum Excel General
    Replies: 11
    Last Post: 01-17-2014, 01:00 AM
  3. [SOLVED] Generate Random numbers where sum = 1
    By sajeel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2013, 07:12 AM
  4. [SOLVED] Generate Random Numbers
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2013, 02:49 AM
  5. Random numbers to generate amount between two numbers
    By maverickbv80 in forum Excel General
    Replies: 2
    Last Post: 09-08-2010, 11:21 AM
  6. Using VBA to generate random numbers
    By matt3542 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-02-2008, 09:15 AM
  7. Generate Random Numbers
    By Rgaherty in forum Excel General
    Replies: 5
    Last Post: 10-30-2007, 04:08 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