Re: random ordering a list in excel

Further to David's suggestion, before you sort use another helper
column filled with a simple sequence 1, 2, 3, 4 etc and include this
in your sort range on the random column. This will enable you to sort
the sentences back into the original order when you are done.

Hope this helps.

Pete

On Jan 28, 11:46 am, "David Biddulph" <groups [at] biddulph.org.uk>
wrote:
Use a helper column with the formula =INT((ROW()+1)/2)+RAND() (assuming that
the first entry is in row 1) and sort both columns by the helper column.
Remember to save the original version  beforehand, so that you can go back
if you need to.
--
David Biddulph

"zhen" <wangzhen0...@xxxxxxxxx> wrote in message

news:141c3671-630a-4098-9fe1-45679892de79@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi, everyone

I am now facing a problem of random ordering a list of sentences in
excel, I will be appreciate if anyone here can help me out.

The context is as this:

I have a list of sentences, from 1 to 200, each two of them are in
pair, thus, the 1st sentence belongs to class 1 and 2nd sentence
belongs to class 2, the 3rd sentence belongs to class 1, and the 4th
sentence belongs to class 2 and so on....(sentences with an odd
numbering belongs to class 1 and sentences with an even numbering
belongs to class 2).

My problem is that, I need to ask some people to classify these
sentences, but I do not want them to find out that, after several
pairs, they know already that the first sentence in the pair belongs
to class 1 and the second one belongs to class 2. Thus I need to
randomize the order of the sentences in the pair, say, in some pairs,
the order of the two sentences is reversed, and the pairs are randomly
choose. (So the people will not find out any rules)

After the person has done, I need to order the sentence into the
original ordering, together with the classification from the person,
thus I can know what will be the answer from the person.

I would be appreciate if anyone can tell me how to realize this? What
kind of functions should I use and how?

Many thanks in advance and hope to hear from you all......- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • aircraft despite Ramzi Dawoods destruction
    ... satisfied and spanish, belongs in front of it, coulding together. ... sort of the establishment's lake. ... co rarely experiences Rifaat, it tears Fahd instead. ...
    (sci.crypt)
  • Re: random ordering a list in excel
    ... David Biddulph ... before you sort use another helper ... pair, thus, the 1st sentence belongs to class 1 and 2nd sentence ... numbering belongs to class 1 and sentences with an even numbering ...
    (microsoft.public.excel.worksheet.functions)
  • Re: hklm/software - virus?
    ... >minding my own business when I was hit by a virus of some sort. ... usually tell what belongs and what does not belong. ... Rename your 'STARTUP' folders for both 'all users' and current logged ... check your explorer shell in the registry. ...
    (microsoft.public.win2000.registry)
  • Re: Memorials: was Re: 2008-12-30) NS-RFC: IMHO, I think fridge space is like...
    ... I didn't realize hospitals allowed you to take that sort of thing ... Actually, it belongs to YOU. ... You can take it home on request. ...
    (rec.food.cooking)
  • Re: At a loss how to sort this file
    ... and it's just you newsreader that wrapped that line? ... Yes the belongs at the end of the line. ... looking at bash sort, but I couldn't ... I was thinking if I had a really large honkin data set, ...
    (comp.lang.perl.misc)