How to sort value in Excel

orientation

Optional xlsortorientation

Specify whether to sort in ascending or descending order.

is wrong. This parameter is not an ascending or descending parameter.

The correct ones are either Sort Row or Sort Column.

Example: a b c

Use. Sort the results of A.

Use. The result of sorting the first row is:

Taking Office 2016 as an example, the steps to add a sort button are as follows:

What we need are: computer, office20161, first open excel**, enter the main interface.

2. Select the cells that need to add a sort button. (It can be a cell in the first row, or a cell in any position, selected according to its content).

3. Then click on the "Data" menu in the upper menu bar, and then click on the "Filter" option button.

4. At this time, the sorted button has been added to the selected cell.

5. Then click the button, and in the pop-up box, you can choose the way to sort or filter.

Tools Raw materials.

Excel 2018 version, computer.

1. Turn on the computer to find and click Excel2018 to create a new worksheet;

2. After double-clicking to open the excel2018 worksheet, in order to demonstrate any text and content in the blank ** in advance;

3. After that, you need to select ** in the first line of adding;

4. After selecting the **, find and click the command of "Filter" in the toolbar at the top right;

5. After clicking the filter, the filter button has been added to the first line of **;

6. After the filter button appears, you can click the button to sort according to your needs.

2. Select the "Filter" option in the pop-up box and click it;

3. You will see the sort button appear on the right side of the first row of cells;

4. Click the button, and in the pop-up box, you can choose the way to sort or filter.

First, find the data column at the top, there is a sorting option in the drop-down menu, and then select the main keyword according to the content, and the secondary keyword can be sorted in ascending and descending order.

Doesn't excel come with a sorting function? And it's also very convenient, why do you need to add this button?

OK.

Step 1: Open the "Tools" menu - "Options" - Custom Sequence "" - Enter the new sequence "Zhao, Qian, Sun, Li, Zhou, Wu, Zheng, Wang" - click "Add" - OK".

Step 2: Select the sequence in Example 2 - "Data" menu - "Sort" - set the selected sequence as the main keyword, select "Ascending" - click the "Options" button - select the sequence set in the first step in "Custom Sort Order" - "OK" - OK".

OK.

1.Open Excel, for example, make ** as shown in the figure below.

2.Select the sorted data area, click the "Data" tab, then click the "Sort" icon to open the "Sort" dialog box, set the keywords for sorting, and then click "OK".

3.The following figure shows the results sorted in ascending order.

4.The results sorted in descending order are shown in the following figure.

5.How to customize the sort order, for example, now you want to sort by "East China", "South China", "Northeast China". From this step to show you.

Click "File" in the menu bar, the interface below will pop up, and click "Options".

6.Open the Options dialog box, click Advanced, and then click Custom List on the right.

7.In the dialog box that opens, enter the custom sequence in the "Enter Sequence" field, click "Add", and finally click "OK" to complete the custom sequence.

8.Select the sorted data area, click the "Data" tab, then click the "Sort" icon, open the "Sort" dialog box, set the keywords for sorting, select "Custom Sequence" in "Order", and then select the sequence just defined in the open sequence, and click "OK" in turn.

9.The final sorted effect is shown in the figure below.

Step1: Create a new customer list: Zhao Qian, Sun Li, Friday, Zheng Wang.

Step 2: Then select all the words in example 2, right-click and select customer sort (order and select custom list, that is, the list you created in the previous step).

This kind of direct operation with Excel is good, large data can be considered with oracle, with C has not tried how to operate with Excel.

1. First of all, open the EXC software, as shown in the example, you can see that the numbers in the "number" and "salary" columns marked in the red box in the figure are in an out of order, that is, there is no certain order, and it is ready to be arranged in a regular order.

2. Drag the mouse to select this **, and the whole ** will be gray after being selected.

3. Next, click on the "Data" tab in the upper menu bar.

4. Click the "Sort" function button.

5. In the pop-up prompt box, you can see a horizontal line marked in the red box. "Columns: Refers to filtering from the key of your ** arrangement; Sort by: refers to the criteria of how you want to sort; Order: Refers to how you want to sort it. ”

6. A horizontal line marked on the red line. Sort according to the "cell value", that is, the data size of the unit, and finally sort "ascending", that is, all the data in the "number" column you selected are sorted from smallest to largest.

8. Select "Cell Value" as the sorting by.

9. Then select "Order" as "Ascending".

10. Click "OK".

11. Finally, it can be seen that the data in the "number" column that was originally out of order are all sorted according to the regular "ascending" rule.

12. Again, if the data is arranged regularly and the colors are inconsistent, you want to arrange the colors in a certain order. As you can see, the "Name" column is divided into pink and green, with pink on top.

13. Select the "main keyword" as "name" first.

14. Then select the sorting basis as "cell color".

15. In the "Order" column, put the color you selected in different positions, select "at the top" or "in the middle", etc. (The demo has green at the top.) ）

16. Finally, looking at the results, the pink name was placed at the bottom from the previous top, and the green name was placed at the top.

Click "Data" in the menu, select "Sort", and then a window will appear, select the column of your age in the drop-down list, and then select "Ascending", OK.

There is a problem with your column of data, and you must have set the numbers to text, otherwise 29 years old will not be ranked in front of 2 years old, because when it is ranked, it is compared to 2 first, the same size, and then it is considered that 9 is younger than the year old and ranked first.

There's nothing you can do, you need to re-set this column of data, the first line is "age (years)", and then the data is simply 28, 2, 40, children under the age of one year are separated into a separate table.

It is indeed more scientific to use the date of birth, after all, the child is 4 months old now, and the next month will not become 5 months.

1 4 Open the excel icon, you will see that the vertical sorting is not continuous.

2 4 Click the first cell first, a plus sign will appear in the lower right corner 3 4 Hold down the mouse and drag down, the same number as the first cell will appear 4 4 4 and return to the first cell, hold down the Ctrl key and drag the mouse down, then there will be a continuous sort.

2.Just click on the heading-data-a-z button where the age is located.

You can use the rank and if functions to achieve automatic arrangement of excel**, as shown below:

1. Function Definition:

The if function is a conditional judgment function, and the formula is =if (to judge the condition, it is executed when the condition is true, and it is executed when the condition is false);

The rank function is a sorting function, and the formula is =rank (the value of the sort, the range of the numerical range of the sort, the sort from large to small or from small to large), where 0 means the sort from large to small, and 1 means that the sort is from small to large.

2. Enter the formula =if($b 3=) in cell C3"","", rank($b 3,$b$3:$b$20,0)), i.e.:

When cell B3 is blank, it will be blank, otherwise it will display the result of rank($b 3,$b$3:$b$20,0);

Rank is a sorting function, that is, the values in cell B3 are sorted in the array $b$3:$b$20, and 0 means that the sorting is from large to small;

3. Drag the C3 cell down to copy.

Please upload a screenshot with a line number and explain your requirements.

How do you sort in Excel? It's simple, let me teach you!

Press the sort button directly after clicking on the data, then press the ascending or descending button.

First enter a starting number (such as 1) and put the mouse in the lower right corner of the cell to become a solid cross, hold down the mouse and pull it down, and it will be automatically numbered.

It can be achieved, but if there is a lot of data, the system may compare cards, and the way is to use VBA:

private sub worksheet_change(byval target as range)

key1:=, 1), order1:=xlascendingend sub

The first step is to right-click on the worksheet tab and select View, as shown in the following figure

The second step, check that the VBA window will appear later, paste the above ** and close, paste ** after the following figure:

If you want to sort the numbers entered in column A in column B, the formula will do the trick. If you have to sort in place in column A, ask the VBA teacher to do it.