+ Reply to Thread
Results 1 to 3 of 3

Taking a random sample from a population of names/contacts

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Taking a random sample from a population of names/contacts

    So I have a list of over a thousand people and I need to take a random sample of 50 or so to include in an e-mail blast.

    Each distinct row corresponds to a certain person with corresponding demographical information in each column. I would like to randomly choose a certain number of rows and have them copied and compiled into a new worksheet.

    If possible I'd like to be able to do this without macros as my VBA knowledge is limited and I'd like to be able to easily adapt the process for different population and sample sizes.

    Can anyone help me out witht his problem? Thanks!

    JD

  2. #2
    Registered User
    Join Date
    08-19-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Taking a random sample from a population of names/contacts

    Here is an example workbook for the problem. For this example say I want a random sampling of 5 rows on the second sheet in this workbook. I also need the sampling to take place without replacement so there will never be duplicates. Thanks again
    Attached Files Attached Files

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Taking a random sample from a population of names/contacts

    You could do it like this:
    Please Login or Register  to view this content.
    The formula in C4 and down is

    =IF(RAND() < ( C$2 - COUNTIF(C$3:C3, "x") ) / (B$2 - ROWS(C$3:C3) + 1), "x", "")
    Entia non sunt multiplicanda sine necessitate

+ 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