how do you randomize a list in excel for mac

How Do You Randomize A List In Excel For Free By Whitelisting

If you want to use decimals, you will have to use a different but similar function.

Next, you multiply this by the difference between the limits and add the lower limit.

For example, if you want to generate a random number between 100 and 110, you must type rand()10100.

Random selections are useful for creating fair, non-biased samples of your data collection.

You can also open an existing Microsoft Excel document if you have one that correlates to your random sample needs.

Once youre positive that youve added all necessary data, youre ready to generate your random sample.

For example, if all of your data begins in column A, youd right-click the A at the top of the page.

The RAND command applies a number between 0 and 1 to your selected cell.

To do this, youll hold down Shift while clicking the cell at the bottom of your data range.

Doing so will paste the random sample command into all selected cells (e.g., A2 through A100).

Once this is done, youll need to sort your data using the random numbers to reorder your results.

Before you can sort your sample, youll need to highlight all of your data.

Doing so will highlight all of your data, making it ready for sorting.

This will bring up a context menu with options that will allow you to sort your data.

You can also click Sort Largest to Smallest here--the only thing that matters is that your data is reorganized randomly according to the RAND() values in the A column.

Depending on how many results you need, your process from here will vary.

If your number of data points is too large to warrant this, you can also settle on a lower fraction (for example, the first eighth of the data).

For example, in a set of 10 data points, you would either pick numbers 1, 3, 5, 7, and 9, or 2, 4, 6, 8, and 10.

This method works best for large sets of data where picking half of the information is too ambitious.

Now you have a non-biased sample pool for a survey, product giveaway, or something similar.

Thats expected since the RAND() formula recalculates a new random number each time you do anything else in the spreadsheet.

Copying the values only (not the formula) over to column B will prevent them from changing in future.

By continuing to use our site, you agree to our cookie policy.

How Do You Randomize A List In Excel For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How Do You Randomize A List In Excel For Mac