TURN TO SUPER COMPLICATED EXCEL NAME SORTING

Sort command;

The main keyword "select" Grades (or column B), "Descending";

Click the OK button;

Enter the number 1 in cell C2 in column C, and formula in cell C3.

if(b3<>b2,row()-1,if(b3=b2,row()-2,""))

After press enter to confirm, use the fill handle to fill down.

Note: If you want to go back to the original order of students by name, simply sort the names in ascending order.

Method 2: Use the rank() function.

Formulas in cell C2.

if（b2="","",rank（b2，$b$2：$b$100,0))

Note: The following $b$100 is a specified 100 rows, and if there are not so many people, the data can be reduced a little.

After press enter to confirm, copy down to the corresponding cell.

Both methods have the same effect, with the same score having the same ranking.

Of course, method 2 is very simple, just figure out the function.

Added: If you want to display the ranking of "=60 points in column b", you can click on the first row, and then click on the data --- filter --- automatic filter, and then click the drop-down arrow in column b, select custom, and the condition is "=60".

Divide the last name column into three columns with the mid function, and excel custom sorting options method stroke sorting, which can solve your problem.

If you want to arrange the same names together in Excel**, you can follow the steps below:

1. In the following table, you want to arrange the same name information in the name column.

2. Select the data in the name column, and the selected logo is the thick black line of **, and then select [Sort] on the "Start" tab in turn.

3. Click [Custom Sorting].

4. Select "Column A" in the "Main Keywords" column and click to confirm the basic bureau.

Add history to the community to learn together].

If you want to know more about Excel, we recommend consulting Miaoke Workplace. With production and research and course research as its core competitiveness, Miaoke Workplace comprehensively uses new technologies such as artificial intelligence, big data, and cloud computing to innovate and develop the teaching mode of "live broadcast of famous teachers + AI guidance + practical operation of students + teaching assistant Q&A".

And based on the flow of the game.

Concept, work with industry experts and consultants to polish the course content, create an immersive learning experience and a professional and systematic knowledge system for students, and help students truly master the hard skills in the workplace.

Just frame the name, and then select ascending order in the sorting and filtering interface. Let me show you the detailed steps:

Computer model: MacBook Air, software version: Excel 2021) 1. Open Excel and select the name you need;

2. Click [Sort & Filter] above;

3. A light gray box pops up, click [Ascending];

4. Sort by name in excel is complete!

The above is the Nachang tutorial on how to sort by name in excel, and it will be helpful to you

1. Step 1: Click any cell in Excel that needs to sort the field. Step 2Open the Sort command in the Data menu, and pop up the Sort dialog box. Trembling mold.

2. Open Excel**, click Data, find Sort, and then click Sort. Automatically pop up the sorting screen, select the name in the main keyword, and click Options. The Sort Options interface automatically pops up, and you can select the Sort Stroke in the method and click OK.

3. Select the area to be sorted and click Sort and Filter. Select Custom sort in Sort & Filter. In the Sort Options screen, select Stroke Sort or Alphabetical Sort. Follow the above steps to sort by name in Excel.

4. Excel** Sort by surname method Figure 1 Sort by surname Step 2: Then select the name that needs to be sorted and the relevant content behind, otherwise the content will not change with the name. The blue part is the selected part.

5. Everyone has fallen into the big pit of your sorting, in fact, the feature that you can only extract one value by using the vlookup function is done, which is quite simple. C1 cell input formula =vlookup(a1,a:b,2,) drop-down formula.

6. Open the excel document that needs to be sorted and select the columns that need to be sorted. In the "Home" tab, find "" and click "Sort and filter". In the options that pop up, select "Ascending".

On the pop-up "Sort Reminders" page, select "Expand Selected Area" and click the "Sort" button.

Click on the Windows Start menu, find Excel, and click Launch. Excel can also be launched by double-clicking the excel shortcut icon on the desktop.

Please click Enter a description.

After starting Excel, if the document does not have a recently opened list, click Browse to find the document and click Open after selecting it.

Please click Enter a description.

After opening the excel document, select the cells that need to be sorted, click on the data and then click the "sort" icon above the "Sort and filter" toolbar.

Please click Enter a description.

In the sort dialog box, select the main keyword as the name column (column B in this example), and select ascending order in order, and by default, excel uses the alphabetical order of Chinese characters to sort.

Please click Enter a description.

If the name column is the first column to sort the selected range, you can also click on the "az" or "za" above to sort and filter in the data toolbar to achieve a quick sort (ascending or descending).

Please click Enter a description.

In the sort dialog box, you can click "Options" to change the sorting method to alphabetical or stroke sorting.

Please click Enter a description.

After Excel is finished, click the disk icon on the Excel Quick Toolbar to save the document.

Please click Enter a description.

The details are as follows:1The first step is to open Excel** on your computer.

Please click Enter a description.

Please click Enter a description.

2.The second step is to select all the data in **.

Please click Enter a description.

Please click Enter a description.

3.Step 3: Click on the Data button in the toolbar at the top of the main page.

Please click Enter a description.

Please click Enter a description.

4.Fourth, click the Sort button in the pop-up page.

Please click Enter a description.

Please click Enter a description.

5.Step 5: Click on the main keyword button and select the name.

Please click Enter a description.

Please click Enter a description.

6.Sixth, click on the order, which can be set according to your needs, and then click the Data including Title button to make it selected.

Please click Enter a description.

Please click Enter a description.

7.Step 7, click the OK button, go back, we can see that the data in ** at this time is sorted by name.

Please click Enter a description.

Please click Enter a description.

1.As shown in the following figure, you need to sort the Date column in ascending order and the Name column in descending order.

2.Select all data regions and click [Data] - [Sort].

3.Because the selected data region contains a title, check the box in the upper right corner.

4.As shown in the figure below, select the Date column to sort the Values in ascending order.

5.Click Add condition in the upper left corner.

6.Select the Name column to sort the Values in descending order.

7.After the setting is completed, click the OK button, and the data returned is the result of ascending column A and descending column B.

Consider creating a secondary column in a blank space, such as C1 to enter the formula:

right(a1,6)

Cut the number part for sorting.

If the numbers in your column E data are all 8 digits after the original data, you can use the following method:

In i1 type:

right(e1,6)

Then scroll down to the bottom.

After that, it is enough to sort the e column in ascending order.

However, if the number of digits or the location of the number is uncertain, you don't know how to get it.

You'll have to help.

If the number of digits is fixed, you can use the right function to truncate the digits.

right(a1,6)

If the number of digits is not fixed, you have to see if there is a 0 in the first part of your number, if there is no 0, you can use the lookup function to intercept:

lookup(9e+307,--right(a1,row(1:15)))

If there is 0, it will be troublesome ......

Then sort the first keyword according to the auxiliary column, and the date is the second keyword in ascending order.

Select the area to be sorted - click "Data" - "Sort" - set the coordinate column and sorting method of the keyword - click OK.