Forum Discussion
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...
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...
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!
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...
shekharreddy Happy to help. Glad it met your requirements. Enjoy!