How to solve the problem of discontinuous serial numbers on the left side of Excel?

Solution: 1. Open the excel table and enter continuous serial numbers below the discontinuous serial number cells in column A; 2. Select column A, click "Data", click "Delete Duplicates", and click " OK"; 3. Select the data in column A, click "Sort" in "Data", and select "Ascending".

Solution:

As shown in the table in the figure; now with these serial numbers, you can see that the serial numbers are not continuously.

So, we use some tricks to quickly complete the breakpoint serial number.

Here in cell A9, we start to enter consecutive serial numbers,

and then select column A; then click on the data option

Click again: Delete duplicates;

In the pop-up dialog box, click OK.

At this time, another dialog box pops up, indicating that 7 duplicate values ​​have been deleted and 16 unique values ​​have been retained.

You can see that although the serial numbers have been added, they are not arranged in order.

Then, we still need to perform the following operations.

Select A2:A17

Still in the data options, click the ascending order icon, as shown in the picture.

After clicking ascending order, the data of A2:A17 will be arranged in ascending order.

Then, this time the operation of completing the serial number is completed here.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to solve the problem of discontinuous serial numbers on the left side of Excel?. For more information, please follow other related articles on the PHP Chinese website!