Home>Article>Software Tutorial> Do you know how to use the 3 advanced sorting methods in Excel?

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

PHPz
PHPz Original
2024-09-03 10:05:16 1050browse

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.

excel 3种高级排序方法,你都会用吗

1. Select any cell that participates in sorting (such as cell B2).
  1. Switch to the [Data] tab.
  2. Click the sort button.
  3. Click the Options button in the pop-up sorting dialog box.
  4. Select Sort by row in the sorting options.
  5. Click OK to return to the sorting dialog box.
  6. Sort by row select row 2.
  7. Select descending order.

    excel 3种高级排序方法,你都会用吗

    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.

excel 3种高级排序方法,你都会用吗

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

excel 3种高级排序方法,你都会用吗

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

excel 3种高级排序方法,你都会用吗

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn