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.
- 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.
If necessary, you could record these steps as a maco.
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?
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?
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?
Related Unresolved Questions