Share via

Sequentialling numbering non-sequential rows.

Anonymous
2024-02-05T20:11:37+00:00

I have 61,000 rows of data. In Col A, some data is there, and some cells are empty. I need to sequentially number those rows that are empty. How do I do this?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2024-02-06T01:31:06+00:00

    =IF(A2<>"","",COUNTBLANK($A$2:A2))

    You may also use countblank formula.

    Image

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-02-05T21:15:53+00:00

    Thank you.

    Was this answer helpful?

    0 comments
  4. Rich~M 20,370 Reputation points Volunteer Moderator
    2024-02-05T21:10:00+00:00

    Hi Teri. I am an Excel user like you.

    Here is a formula that will number the rows that are blank. Enter in Row 2 of your data (assuming that that is the first row of data or modify the references to match your first row) and drag down.

    =IF(A2="",COUNTIF($A$2:A2,""),"")

    Was this answer helpful?

    0 comments