Results 1 to 20 of 66

Thread: Help Required : Random Sampling of Data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #33
    VBAX Mentor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    314
    Location
    Hi Paul!,

    It is almost ready after 2 months to share with my team members. Thanks for your continued help so far.
    I have made few changes in codes to facilitate the option of picking samples from selected strata in list box by adding the selected values to an another collection called "StrataList2".
    I request your help in the following -

    View statistics is taking long time if the number of strata values are more. For example, "NetAmt" in the sample file attached. Is there any alternate way other than the currently used countif to load the statistics faster?
    cntArray = Application.CountIfs(rRange, StrataList(iStrata))
    Thanks in advance!
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •