Fill in numerical sequence?

[hpon]

Hi,

I have an incomplete numerical sequence that I would like Excel to automatically complete with the missing posts. Example:

2
5
6
7
9

Should be:

1
2
3
4
5
etc.

Do you have any tips on how to accomplish this?

Best Regards,
hpon

[zbor]

if your data is in A column use this in B2: =IF(B1<MAX(A:A), ROW(B1), "")

[hpon]

if your data is in A column use this in B2: =IF(B1<MAX(A:A), ROW(B1), "")

Thank you very much for your reply zbor!

I forgot to mention that the data consists of several columns; one enumeration column and a few columns of corresponding info. The enumeration should be continuous, but the info columns should be blank where new rows (numbers) have been added. Could the command be modified to generate such modifications?

/hpon

[zbor]

Upload example workbook

[hpon]

Upload example workbook

OK, see attached.

[hpon]

OK, see attached.

Can't find the attachment in the thread, so I try again.

See attached.

[zbor]

Click Edit post, Go advanced, use paper clip icon to attach file.