+ Reply to Thread
Results 1 to 7 of 7

How to generate a random samples from an employee data without repeat.

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to generate a random samples from an employee data without repeat.

    hello all

    i have attached a Excel sheet where i have four employees in it.

    i want to generate atleast 2 random samples of each employee without repeat.

    i want that entire row in the output.

    please help...

    thamks.
    Attached Files Attached Files

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to generate a random samples from an employee data without repeat.

    you have 19 employees there
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to generate a random samples from an employee data without repeat.

    In the attached example, the samples are in cells A24 and A25
    Attached Files Attached Files
    Gary's Student

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to generate a random samples from an employee data without repeat.

    In this version the complete data is sampled
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-06-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to generate a random samples from an employee data without repeat.

    thanks for the reply but

    let me say in the excel sheet which i have posted, from the A2 to A4 cells have the employee details with similar last names (smith), from A6 to A11 (jackson), A13 to A17 (henderson) and from A18 to A19 (douglas).

    together there are four last names.

    now i need the 2 samples of each last name without repeat.

    hope u got my question.

    please help

    thanks.

  6. #6
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to generate a random samples from an employee data without repeat.

    Here are two sample of each name
    Attached Files Attached Files

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to generate a random samples from an employee data without repeat.

    that does not work if a2=Douglas

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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