sampling

  1. M

    Sampling

    Hello: I have a database with the sales of an entire month of a department. I have a column with the seller name, one with the sold item and the rest of the table with detail of the item sold. I need to identify a random sample of 25% for each seller (not all of them sold the same amount of...
  2. S

    5% Random Sample with Two Variables

    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...
  3. F

    How to automatically randomize data on Copy / Paste?

    Hello everyone, It was necessary to create an automatic sampling program in Excel, which has 5 columns on the first sheet that contain the following: Sheet 1: Column A: follows RAND() under this idea “=IF(B2>1;RAND())”. Columns B to E have the data that are to be filtered randomly. Sheet 2...
  4. F

    Extracting data from one list and sorting it into another

    Hi All, I am having a problem with the extraction of data from one list to another. The problem that keeps coming up is that I have a master list for some data that I am attempting to take a number of smaller lists to add onto it. The problem is that the smaller lists do not have the full...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top