Forum Discussion

shekharreddy's avatar
shekharreddy
Copper Contributor
Jul 31, 2020
Solved

Sampling category wise percent

Hello, I have few comments in my work and I need to take samples from those comments percentage wise. Example: comments: 1. New Company, 2. Updated File, 3. Checked. 4. All Good The total comments...
BI & Data Analysis
developer
excel
Formulas and Functions
  • TheAntony's avatar
    TheAntony
    Aug 01, 2020

    shekharreddy , VBA not necessary. See attached with both the new Dynamic Array and old Legacy formula options.

     

    Also, your Sample counts don't evaluate to whole numbers, so I had to round them. This makes the sample size 22 instead of 23. FYI...

Ramiz_Assaf's avatar
Ramiz_Assaf
Iron Contributor
Jul 31, 2020

shekharreddy 

can you elaborate more, can you provide an example excel sheet (not the original) but something similar so we can understand your problem better.

    • shekharreddy's avatar
      shekharreddy
      Copper Contributor
      Aug 01, 2020

      Thank you for the videoRamiz_Assaf 

       

      it included some manual work so could you please write a VBA code for this one.

       

      Thank you in advance!

      • TheAntony's avatar
        TheAntony
        Iron Contributor
        Aug 01, 2020

        shekharreddy , VBA not necessary. See attached with both the new Dynamic Array and old Legacy formula options.

         

        Also, your Sample counts don't evaluate to whole numbers, so I had to round them. This makes the sample size 22 instead of 23. FYI...

Resources