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...
Yeah, You are correct. I just realized.. I'm sorry it's my mistake.. could you please help me to get serial number from original series.. then only the sample works..
shekharreddy , here you go...
- This is perfect now- Thanks a lot!!!