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!