randomly selection

[Shea]

I need to randomly select 300 entries from a master list of 950 entries.
Ideally I would like to choose every thrid entry. How do I undertake this
task?

[Domenic]

Assuming that A2:A100 contains the data...

For every third entry, starting from the first cell in the range:

=INDEX($A$2:$A$100,ROWS($B$2:B2)*3-3+1)

For every third entry, starting from the 3rd cell in the range:

=INDEX($A$2:$A$100,ROWS($B$2:B2)*3)

Hope this helps!

In article <[email protected]>,
Shea <[email protected]> wrote:

> I need to randomly select 300 entries from a master list of 950 entries.
> Ideally I would like to choose every thrid entry. How do I undertake this
> task?