If Column A is not already empty, add a column to the left of it. Then you will copy and paste the random values to another column, which you will then sort in ascending order. When selecting a random sample from a collection of data you must first assign a random number to each row. By using this feature, you can assign a random number to each row in a set of data and sort them randomly.
This article is based on legacy software.Įxcel has the ability to generate random numbers from zero to one or from pre-selected number ranges. (Archives) Microsoft Excel 2007: Getting a Random Sample Mac
