Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Randomisation
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Randomisation
Resolved · Low Priority · Version 2003
Reply
Randomisation
I have N AxB region of cells. How do I randomly select exactly 10 of the cells, in total, from within all of the regions.Ideally this would be a function:
=randomise(region,sample_size)
where region is the name given to multiple groups of cells (N AxB) and sample_size is the number of cells I need to randomly select (N).
I would imagine this requires indexing every cell in 'region' and then randomly selecting 10.
Thank you in advance.
For upcoming training course dates see: Pricing & availability
RE: randomisation
Hi AngeloThanks for your post and detail of what you are looking to do.
We have reviewed this and are confident we can find a solution to you although it will be beyond what we can achieve in this forum.
In these cases we would ask for you to send us your working files so that we can let you know the scope of work and any related costs. We will not commence any billable work until we have checked with you.
If you would like to discuss this option further please do contact us.
Kind regards
Jacob
Tue 23 Mar 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Calender |
How to invite people to meetings.
