+ Reply to Thread
Results 1 to 2 of 2

generate random results, removing only SOME duplicates

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    GB, WI
    MS-Off Ver
    Excel 2010
    Posts
    41

    generate random results, removing only SOME duplicates

    I've attached an example workbook.

    Right now, I have it functioning where the report tab will read the data from the DATA tab, then remove duplicates of that data when the "Generate Report" commandbutton is pressed, leaving only one person with the same name listed. I would like to add the option of choosing how many duplicates to remove, leaving a desired amount of persons with the same name listed, if there are that many. For instance, my example includes 4 "joe smith"s, 1 "tracy johnson", and 2 "steve wright"s. I want to be able to choose to leave 2 of each. So that would leave 2 of the "joe smith"s, and the still populate the 1 "tracy johnson" and the 2 "steve wright"s. And/or I want to be able to choose to leave 3 of each, which would then leave 3 of the "joe smith"s and still populate the 1 "tracy johnson" and the 2 "steve wright"s, etc, etc.
    Is this possible? if so, how? Thanks!

    example.xlsm

  2. #2
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: generate random results, removing only SOME duplicates

    This is a VBA issue and not a formula & function issue. Please post in the appropriate sub thread.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

+ 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 6-16-byte random hexadecimal number
    By jsamuelshn in forum Excel General
    Replies: 6
    Last Post: 07-20-2012, 10:38 AM
  2. Auto-Generate random set of four numbers without duplicates?
    By adrien23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2011, 06:03 PM
  3. Removing Duplicates based on two Columns, Output results to new Spreadsheet
    By crush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 02:26 PM
  4. How to generate sets of random numbers without having duplicates
    By William in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2006, 12:35 AM
  5. generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 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