Why is it that after advanced filtering in excel tables, the filtering results are sorted by 1, 2, 3, 4, and the drop-down will not sort automatically? How to sort the filtered results?

1. First, open the excel table. For easy viewing, add a new column to the right of the data to store the fields that will be sorted automatically after filtering.

2. In the first cell of the auxiliary column, enter function =SUBTOTAL( 103, $C$2:C2) and set the first serial number.

3. At this point, all serial numbers are set by drop-down, as shown in the figure below.

4. Finally, filter the data as needed, and you will find that the original serial number will change discontinuously, while the serial number on the auxiliary column will automatically change the order and reorder, and it is completed.

Three-time bachelor of mathematics

Guangdong college entrance examination mathematics variance compulsory knowledge point

When was Einstein from? What contribution did he make to people?

Relationship between power amplifier and loudspeaker

Five elements method of mathematics

Mathematical separation

How to solve the plane vector problem 16 in senior high school mathematics?

What math skills does it need?

How to write the beginning and end of all kinds of people?

What textbook did Cangzhou, Hebei Province learn in mathematics last semester?