sequential numbering in excel 2003

i would like to get a formula/vba to place sequential numbers in column b and also to find the first blank in a range
Who is Participating?
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:

Should the sequential numbering only apply to rows with values in column [E], like your example?  Or, do you simply want the numbers 1 to 14 in cells [B19:B32]?

(Mind you, I am unsure why cell [B22] has a value of 3, yet there is no value 4 as cell [B25] has 5)

For all rows in this range to be filled...

Place this formula in cell [B19]:
Copy this cell down column [ B ] to [B32].

For rows with values just in column [E]...

Place this formula in cell [B19]:
Copy this cell down column [ B ] to [B32].

Please see the attached workbook for examples of both of these methods.

Finally, how would you like "the first blank" (in range [E19:E32]) to be identified?  By row, by cell reference, or by some other method?

Thanks for your clarification.


SvgmassiveAuthor Commented:
cell reference
[ fanpages ]IT Services ConsultantCommented:
Entered as an array formula (use [CTRL]+[SHIFT]+[ENTER] instead of just [ENTER]):


See cell [I23] in the (updated) attached workbook.

Note: This formula returns "E0" when cells in the range may appear blank but are, in fact, empty.

Assuming that the contents of [E19:E32] will always be numeric values, then this formula will report the correct address:


See cell [I25] within the attachment.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.