I need to do an audit of 5% of each of my coworkers complaint files. I pulled the data so that Column A contains the complaint file number, and Column B contains the complaint owner. There are about 7 different owners, but every complaint file number is different.
I need to pull out a random sample of 5% of each owner's complaints. Each owner does not have the same number of complaints, so 5% of one person's complaints might mean 10 complaints, by 5% of another person's complaints might mean 25.
I will be doing this audit monthly, so I'm looking to write a program or something so I just update my source data each month and it will generate a random sample of complaint file numbers from Column A.
Please let me know if I'm not explaining this well! Trying my best
I need to pull out a random sample of 5% of each owner's complaints. Each owner does not have the same number of complaints, so 5% of one person's complaints might mean 10 complaints, by 5% of another person's complaints might mean 25.
I will be doing this audit monthly, so I'm looking to write a program or something so I just update my source data each month and it will generate a random sample of complaint file numbers from Column A.
Please let me know if I'm not explaining this well! Trying my best