On 8 Jul 2001 23:17:37 -0700, [EMAIL PROTECTED] wrote:
> From: [EMAIL PROTECTED] (Neville X. Elliven)
[ ... ]
>
> <<If by "rearrange" you mean "exchange", the TRANSPOSE() function
> in Excel does this; if you mean "sort", then the Data>Sort command
> does that; but if you mean something else, then you'll have to be more
> specific.>>
[ ... ]
> Third, I am using the Microsoft Works for Windows spreadsheet. It
> does not have a transpose command, and only sorts in ascending
> or descending order --- which ain't all that much help. I can do what
> I want to do manually. But that gets mighty old, mighty quick.
>
> Fourth, as to what it is I want to do, let me just say that I wish to enter
> data in a matrix like that I've attached ('tis virus free I assure you,
> no hacker I --- I swear on my edstat honor) and rearrange the Actors
> so as to produce the pattern I like best on both qualitative and
> quantitative grounds.
[ snip, rest ]
- It sounds to me as if Numbering and Sorting would be easy
for you, a natural for your problem.
I have fallen back on that solution even when I had other
tools available; it offers flexibility, especially if your
numbering/labelling is done as several fields (columns).
--
Rich Ulrich, [EMAIL PROTECTED]
http://www.pitt.edu/~wpilib/index.html
=================================================================
Instructions for joining and leaving this list and remarks about
the problem of INAPPROPRIATE MESSAGES are available at
http://jse.stat.ncsu.edu/
=================================================================