How can i randomly select data in excel

And then drag the fill handle to cover as many cells as desired selections. The above two methods can display the random cell values in a new column, and they are only applied for a single column range, not work for a range of cells.

Kutools for Excel's Sort Range Randomly tool can help you select cells randomly in an original range conveniently. After free installing Kutools for Excel, please do as below:. Then click OK or Apply. Select random 10 cells from the selected range.

Select random 5 rows from the selected range. Select random 4 columns from selected range. Advanced to select random cells, Sort Range Randomly of Kutools for Excel can sort data randomly in whole range, in each rows, in each columns and so on. Randomly sort cells in a column or range.

Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. How to select cells randomly in Excel?

Select cells randomly from a column with formula Select cells randomly from a column with User Defined Function UDF Select cells randomly from a range with Kutools for Excel Select cells randomly from a column with formula As the following screenshot shows, you have a range of data from A1 to A15, the Rand and Index formula can help you display the random cells in a new column. Please do as follows: 1. See screenshot: 2. Click for full-featured 30 days free trial!

Fill in your details below or click an icon to log in:. Email Address never made public. Follow Following. Sign me up. Already have a WordPress. Log in now. Loading Comments Email Name Website. Post was not sent - check your email addresses!

Sorry, your blog cannot share posts by email. For example, if you have 3, customers and you would like to select a random sample of to receive a customer satisfaction survey, follow these steps:. To make sure the number of respondents in your random sample are statistically significant, check out this blog post.

Random samples make it easy to get feedback from a large population for any of the following:. Products Surveys. Specialized products. View all products. Survey Types. People Powered Data for business. Solutions for teams. Explore more survey types. Curiosity at Work.