Results 1 to 2 of 2

Thread: Create list of random items based on weighted average without duplicates

  1. #1
    Neophyte anna's Avatar
    Join Date
    Jun 2019
    Posts
    1
    Articles
    0
    Excel Version
    Microsoft Office 2019

    Create list of random items based on weighted average without duplicates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am trying to create a list of random items based on their popularity, but struggling to make it work due to the fact that it can not contain any duplicates.
    It will be used to generate a picking list of about 10 items from a list with over 200 items.
    =MATCH(RAND(), ) creates the list, but I have not yet found a solution to remove and replace the duplicates with a new unique number, not with the use of VBAs either.


    Any help?

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    161
    Articles
    0
    Excel Version
    2019
    Here is a random selection order of the 50 states. You can adapt this to your situation
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •