Can you do random data sorting in Excel, shuffle the order

Let's start by looking at the raw data. The current data is sorted according to the Name field, and the data of the same person is sorted together in order. The order needs to be shuffled randomly.

Double-click the E2 cell and enter the function:

rand()

After entering, the cell will return a random number less than 1 and greater than 0.

Knowledge point description:

The rand() function is a function that returns a random number, does not require a parameter, and returns a value between 0 and 1. Generally speaking, in a worksheet, multiple cells run the rand() function at the same time, and the results returned are not repeated.

Double-click the fill handle in the bottom right corner of cell E2 to fill the function to column E.

Copy the data in column E, select [Paste Special] from the right-click menu, and select [Value and Number Format].

After pasting, the return value of the rand() function in column e will be converted to a numeric value.

Note: You can sort directly without pasting as a numeric value.

Select the data in columns A to E, and select Data - Sort.

Select [Column E] for the main keyword, in ascending or descending order, and then click the [OK] button.

After completion, the effect is as follows, and the data under the [Name] field has been randomly sorted.

Principle note: Since the numbers in column e are random numbers, the ascending or descending order is already a random order for the original sort order. Therefore, using this method to sort is to obtain a random arrangement of the original order.

Finally, organize the data, delete column e or clear column e data.

Here are the reference links.

Excel can use the rand function to shuffle the order of data at will. Here are the specific steps to scramble.

1. First of all, on the computer, open the excel sheet that needs to randomly shuffle the order of the data. In the last cell of the first data [F2], enter the function formula =rand().

2. Press the [Enter] key on the computer keyboard to generate random numbers.

3. Select the [F2] cell and fill in the formula downward. A random column of numbers is generated.

4. Select this column of random numbers, click [Data] in the menu bar, and click [Ascending].

5. Select [Expand Selected Area] and click [Sort].

6. At this time, the order of the data can be randomly shuffled, and [a random number generated] can be deleted.

The input function rand generates a random decimal and then fills the decimal down. Next, right-click and select "Ascending" in "Sorting". It randomly shuffles the order of the data. Detailed steps:

1. First of all, enter the equals sign in the right cell as shown in the following picture:

2. Then, enter the function rand, as shown in the figure below:

3. Then complete the right bracket of the function and confirm, as shown in the following figure:

4. In this way, a random decimal is generated, as shown in the figure below:

5. Fill this decimal downward, as shown in the figure below

6. Then right-click and select "Ascending" in "Sorting", as shown in the following figure:

7. In this way, the order of the data is randomly shuffled, as shown in the following figure:

Methods of random sorting in excel:

Random sorting step 1: First we open a list, and we want to arrange an exam order for these lists.

Step 2: Enter the "Exam Serial Number" in cell I2 of the last column of the **.

Step 3: Enter =rand() in the cell below the exam number, i.e. cell i3

Random sorting step 4: Punch and then select i3, click the mouse in the lower right corner of the illustrated position, and drag down to the lowest end of the **, so that a column will be automatically filled.

Random Sort Step 5: We get the number of a car.

Random sorting step 6: We select this column of random numbers, but do not select the words "exam serial number".

Sort Randomly Step 7: Click on the sort icon on the top of the toolbar, and you can see what the sort flag looks like in the icon.

Random sorting step 8: Click on a household, a prompt box will pop up, we choose to sort the selected area before the hunger search. Then click Sort.

1. First of all, open the excel** that needs to be manipulated quickly.

2. Then enter the "=" sign in the E2 unit to add the auxiliary function rand.

3. Press enter in cell E2 and pull down the copy function in the lower right corner of cell E2. Limb searches.

4. Select Sort and filter in ascending order, descending order.

5. You can see that the random sorting is completed.

5. Finally, save the file.

When working in Excel, in some cases, you need to randomly shuffle the order of the original ordered data, how to do it? Let's take a look.

1. Start Excel and open the worksheet, enter the formula in the H2 cell outside the data area"=rand()"Press the Enter key to get the result. Drag the fill handle to fill the formula into other cells of the column as shown in Figure 1.

Figure 1 Create a formula and fill it into other cells.

2. Click the Sort & Filter button in the "" group of the "Start" tab, and select the "Descending" command in the menu that opens, as shown in Figure 2. In the Sort Reminder dialog box, select the "Expand Selected Area" radio button, and click the "Sort" button to start sorting, as shown in Figure 3.

Figure 2 Descending command.

Figure 3 Sort Reminder dialog box.

3. At this time, the data in the worksheet will be arranged in descending order according to the size of the random number generated, so that the random sorting effect is obtained. Select the range of cells where the random number is located, and press the delete key to delete the data in it to get the worksheet you need, as shown in Figure 4.

Fig.4 Randomly sorted worksheets are obtained after deleting random data.

1.Tricks of excel random out of order.

2.Methods of random sorting in excel:

3.excel2007 how to sort out of order.

You can add a random sequence to the end of the column, use the rand() function to get the specific data, and then sort the column. The rand() function generates a random number between 0 and 1 rows of widths, with 15 decimal places, so the data obtained is generally not repeated.

The rand function gets the random number sort.

Inject lead traces in b1 to destroy the state or copy and paste the following formula.

rand()

Double-click the B1 fill handle to fill the formula downward.

Select any non-empty cell in column B, data, sort and filter, and click the ascending or descending icon (single or multiple times).