G
Guest
I have multiple worksheets containing between 200 - 4000 data items of which
I need to take a random sample of 50 and enter the details of these 50 only
in another worksheet. To obtain a random sample across the whole group, if
there were 200 files then I would select every fourth file. Currently I am
linking the first records, filling the series down to 50 records and then
manually amending every formula link to recognise the next row I wish to
select (eg. every fourth). Is there an easier way I can do this, (I cannot
sort the data in a way that the first 50 shown are the random sample.)
Any ideas would be much appreciated.
I need to take a random sample of 50 and enter the details of these 50 only
in another worksheet. To obtain a random sample across the whole group, if
there were 200 files then I would select every fourth file. Currently I am
linking the first records, filling the series down to 50 records and then
manually amending every formula link to recognise the next row I wish to
select (eg. every fourth). Is there an easier way I can do this, (I cannot
sort the data in a way that the first 50 shown are the random sample.)
Any ideas would be much appreciated.