+ Reply to Thread
Results 1 to 17 of 17

Random Sample w/Priority

Hybrid View

  1. #1
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Random Sample w/Priority

    Mick - Thanks for the quick reply. Just to confirm, when i choose random it is likely that a Car purchase is going to end up an Apple/Banana correct?
    If you choose ("Random Item = No"), then you will get a random item that is NOT "Car".
    If you choose "Car = "yes", you will get "Car"

    Just to clarify my original question... if you were to edit the list of items purchased and number the "Car"s (Car1, Car2, Car3)... the randomized result would have the specific value of 'K'?
    I don't understand this, can you explain or perhaps show an example !!!
    Last edited by MickG; 06-26-2019 at 09:32 AM.

  2. #2
    Registered User
    Join Date
    11-14-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: Random Sample w/Priority

    im re-attaching the file for a better explanation... (ive added multiple Cars and numbered them)
    My question was in regards to identifying the serialized Car, rather than just "Car".
    Attached Files Attached Files

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Random Sample w/Priority

    So if you Select "Car = "Yes" " from the msgbox do you want to return a random car from those available, or something else ???

+ 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] Random Sample
    By JThirsty in forum Excel General
    Replies: 3
    Last Post: 02-16-2018, 10:05 PM
  2. How to get a random sample from list
    By mrotsliah in forum Excel General
    Replies: 2
    Last Post: 10-10-2014, 03:03 PM
  3. Random Sample with Parameters
    By alexandrite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2011, 01:29 PM
  4. Random Sample
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2009, 07:31 PM
  5. Assigning random priority with RAND function
    By stabilizer in forum Excel General
    Replies: 3
    Last Post: 05-11-2007, 03:46 AM
  6. Random sample
    By RIROCKHOUND in forum Excel General
    Replies: 1
    Last Post: 11-09-2006, 07:17 PM
  7. random sample
    By skimpw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2006, 08:15 PM

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