Tips for Excel positioning padding

Today suddenly found a positioning of the filling of small tips, as to where it can be applied to what effect, this also needs to be together with the pig in the future operation of the summary, then, together to see this technique, personal feeling or very learning value.

　　Tools/raw Materials

Excel for Office series

　　Steps/Methods

First, let's take a look at the data we're going to use this time, and I'll talk about some of these tips in the application process.

We add a few sequences to facilitate the next operation, and the added method is to copy the existing sequence and then select the cell to move down when pasting.

After the sequence creation is complete, we arrange the sequence in ascending order.

Then we will position the data after the arrangement, the shortcut key is: Ctrl+g, we set the positioning conditions.

The null value is positioned, so we choose null value.

The system selects all the null values for our next operation.

We'll give the top-most value of each sequence +1, so that all null-value cells achieve this effect.

After the input formula is finished, it is necessary to note that the Ctrl+enteris not the direct point of the enter key.

In this case, we'll copy the populated cell values.

And then paste it into the cells we need, which is similar to the one in the known condition that requires unknown, regular values, which is easier to use.