Sort Data in a Column Randomly in Microsoft Excel

Topic: Excel, Office Product: Microsoft Excel Related Articles: sort randomly excel2007 sorting qtp datatable based column write formula random electricity bill excel

It is very necessary to get rand order of a group data for better sample or task allocation. This is the solution to sort the data in a single column in random order. I use the Rand() function in Microsoft Excel to finish it.

sponsored ads

Solution

For example, I want to sort the data from A1:A10 randomly in Microsoft Excel 2010.
Click on the B1 cell, then activate the B1 formula bar. Type the =rand() function and press Enter key to get the result.
Now drag the formula from the B1 to B10 to generate 10 random numbers. This is the key step. Because the data in Column B is random, so if i sort A1:B10 by the Column B, I'll get random order for the data in Column A accordingly.
Make a selection of A1:B10, and click on the range, choose Sort->Custom Sort menu.
In the Sort dialog-box, choose the Column B from the Sort by drop-down list. Click on the OK button to apply the sort.
Now Column A data is in random order and Column B is unnecessary.
Click on the Column B and Delete it.
Finally, I get the random result.

Tips

If necessary, you could record these steps as a maco.

How to Sort Data by Cell Color in Microsoft Excel

Sometimes different thing is distinguished by there colors, I know Excel have the feature that allows you to sort data by the cell background color or by font color so I can easy discriminate the date. But I do not know where to set it, can you help me?

How to Use Column Chart with Markers to Compare Data in Microsoft Excel

I am a sales man in a computer company. And at the end of this month, I have to present a report about my sales and targets. You know, I want to compare these two kinds of data in Microsoft Excel. But I have never used this function of Excel application. So could someone tell me how to solve this problem?

How to Make Column Chart or Bar Graph in Microsoft Excel

I need to create a excel chart for my boss this Friday to have a introduction for the company's production. I thought it was an easy thing because I have created ones before. However, he asked me to make a chart with 3-D effect. The reason is that this kind of chart can give audience strong impression. But I have no idea about this chart. Could someone tell me how to make a column chart or bar graph with 3-D effects in Microsoft Excel?

Search for Related Topics

sort data textpad sorting data vb6.0 sort data listview vb6 jcl sort data csv vba listview sorting data sort data notepad c# sort data notepad++

Related Unresolved Questions