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.
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
