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?
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?
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 <E2FE0733-0CDD-4131-A126-5DC7133606AB@microsoft.com>,
Shea <Shea@discussions.microsoft.com> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks