Let's say I have an excel Sheet where in the first column is:
1
3
4
7
10
How can I quickly fill up this list with the missing ascending whole numbers such that it reads? An alternative way to put it is that I want to fill in the list of ascending numbers, adding a row for each missing number
1
2
3
4
5
6
7
8
9
10
Many thanks.
Bookmarks