• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA for Sampling: Stratified random sampling

Hi All,

Have tried to built Sampling random Add-in, please review and let me know.

This version, have built for more than one component (filed) or partition random values. If you want to use this for one or no partition value then just insert one column with same value (like 1 or 2) and run this Addin –

How to install Add in –

Press ALT+T+I then browse.. and select add-in then OK

https://www.dropbox.com/s/3smji7talqvfkqa/StratifiedRandomSample.xlam?dl=0
 
Hi All,

Have tried to built Sampling random Add-in, please review and let me know.

This version, have built for more than one component (filed) or partition random values. If you want to use this for one or no partition value then just insert one column with same value (like 1 or 2) and run this Addin –

How to install Add in –

Press ALT+T+I then browse.. and select add-in then OK

https://www.dropbox.com/s/3smji7talqvfkqa/StratifiedRandomSample.xlam?dl=0

Hi I downloaded the code and trying it on office 2016 64 bit windows 10 64 bit, but it gives an overflow error regardless of the settings.
 
Back
Top