Do you know how to use the 3 advanced sorting methods in Excel?

In excel tables, the sorting function is often used, which sorts data according to specific rules or conditions. So do you know how to use advanced sorting in excel? What I want to share with you today are 3 advanced sorting techniques in Excel. Friends who need them can come and learn them. 1. Sorting by rows What we usually use most is sorting by columns, that is, vertical sorting. What should we do if we want to sort by rows? As shown in the picture below, we want to sort from high to low sales amount.

1. Select any cell that participates in sorting (such as cell B2).

2. Switch to the [Data] tab.
3. Click the sort button.
4. Click the Options button in the pop-up sorting dialog box.
5. Select Sort by row in the sorting options.
6. Click OK to return to the sorting dialog box.
7. Sort by row select row 2.
8. Select descending order.

   

   2. Sort by color

As shown in the picture below, we need to sort according to blue-green-red. First switch to the [Data] tab , click the sort button, in the pop-up dialog box, select the cell color for sorting, and then add the sorting color in sequence to sort by color.

3. Custom sorting We need to arrange the data in the table below in order of computer - printer - supplies - furniture.

1. Switch to the "Data" tab

Question: How to sort a PHP array alphabetically? In order to facilitate the management and manipulation of data in PHP arrays, sometimes we need to sort the array elements. PHP editor Xiaoxin will introduce two methods of sorting PHP arrays in alphabetical order in this article, and provide detailed sample code. Read on to learn the specific steps and uses of these methods.

3. Select "Custom sequence" in the sorting dialog box

4. Enter the custom sequence

• Enter one sequence item per line
• Press Enter to change the line

5. Add a custom sequence

6 . Click "OK" to complete

The above is the detailed content of Do you know how to use the 3 advanced sorting methods in Excel?. For more information, please follow other related articles on the PHP Chinese website!