Non-sequential row numbering

Sorry if this has been asked and answered before, but my searching for an answering has come up empty. I have a two-column spreadsheet, and I need to identify the order in which data will be entered. So I'll enter a value in column A, and I want column B to be automatically populated with the next number. However, the data in column A will be entered randomly, not sequentially. So I want results that look something like this:

excel data sample.jpg

I've tried an IF statement that tests for blank cells and increments the MAX function, but column B gets renumbered sequentially as data is entered in new rows. Any help would be greatly appreciated. Thanks!

Hi Joelh327,
Welcome to the forum.

I'm not able to provide the desired formula. However, here's a possible solution using VBA code.
HTH!

Hi jewelsharma,

Thanks for the welcome, and an even bigger thanks for the VBA code! It's exactly what I was looking for!

Joel

Hi Joel!
Happy to help.

Please take a moment to go through Forum FAQs and do mark the thread as SOLVED. Here's how:

Method 1
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Method 2
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save