Date:         Thu, 2 Sep 1999 15:58:04 -0500
Reply-To:     "James B. Luther, Ph.D." <jluther@ALUMNI.INDIANA.EDU>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "James B. Luther, Ph.D." <jluther@ALUMNI.INDIANA.EDU>
Subject:      Re: Random Sort in Excel
Comments: To: Stephen Salbod <ssalbod@FSMAIL.PACE.EDU>
Content-Type: text/plain; charset="iso-8859-1"

Stephen:

One simple suggestion would be to generate a column of Random numbers (using
the Data Analysis function and whatever type of distribution you want) in a
column generating as many random numbers as you have SSNs. Then simply sort
the spreadsheet (both the Random Number Column and the SSN column) based on
the value in the Random number column - this should rearrange the SSNs into
a random order. A more precise method would be to use the Random # Generator
function in VBA to randomly select SSNs and place in a different worksheet -
this would require writing some code.

HTH

Jim Luther

James B. Luther, Ph.D.
Luther Consulting, LLC
317-371-4739
-----Original Message-----
From: Stephen Salbod <ssalbod@FSMAIL.PACE.EDU>
Newsgroups: bit.listserv.spssx-l
To: SPSSX-L@LISTSERV.UGA.EDU <SPSSX-L@LISTSERV.UGA.EDU>
Date: Thursday, September 02, 1999 12:27 PM
Subject: Random Sort in Excel


>Hi Everyone,
>        I have list of SSNs in an Excel table that I want to put in a
random
>order. I don't seem to see how I can do it. I check tools->sampling, but to
>no avail. Is SPSS my only recourse? TIA
>        Stephen Salbod, Pace University, Manhattan
>