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...
can you elaborate more, can you provide an example excel sheet (not the original) but something similar so we can understand your problem better.
It is hard to automate without VBA
so please find a simple solution without programming or formulas
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!
