Return a random number of references 1

[Suggie]

Hello,

I have a list of references e.g. 200218561, that are in column C, they go down to row 80 and are individual.

I need to retreive exactly 26 random references for sampling purposes. I've tried rand but can't figure it.

Any ideas?

As usual, TIA,
Mark

 

[SkipVought]

Hi,

In a adjacent column you enter a random function on each row
[tt]
=rand()
[/tt]
Sort on that column each time you want a new set.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Suggie]

Sorry, I don't think I explained it correctly:

For example, in column C say I have the following:

Mark
Paul
Dave
Phil
Rob

If I wanted to randomly return three of these names into Column D, how would I do that? For example, in D I would have randomly returned:

Rob
Dave
Mark

Thanks again,
Mark

 

[SkipVought]

My solution works perfectly, except in column D I have =Rand() that I sort on and then in column F you can have
[tt]
F1: =C1
F2: =C2
F3: =C3
[/tt]
3 differrent name each time you sort on column D.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Suggie]

Thanks Skip.