Results 1 to 20 of 66

Thread: Help Required : Random Sampling of Data

Threaded View

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

    I was testing this tool in different work books and I would request your help in the following 2 areas-

    (1) How can I sort the strata list based on the count in descending order and show in the list box
    UF_StrataList.lbSummary.List = aryList
    (2) How can I pick samples only for the selected strata item from the list box. In the attached example, if I select the column "DenialCode", 90% of the line items are "blank". Hence, I want to skip the strata "blank" and pick the samples only from few selected strata items.
    If there is a selection, pick samples only from the selected strata or else pick from all

    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
  •