98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Randomisation
Randomisation
Resolved · Low Priority · Version 2003
Sun 14 Mar 2010, 13:56Delegate Angelo said...
Angelo has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Advanced course
Access VBA course
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.
Wed 17 Mar 2010, 09:35Trainer Jacob said...
RE: randomisation
Hi Angelo
Thanks 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.
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. |
Excel tip:Finding cells that have data restrictionsClick anywhere on the worksheet. |
