The next number should be easy

Yes it should be easy.....

I have a list that I want to automatically enter the next highest number in the list into the first cell of a row when I enter data to the rest of the row... untill then the cell should be blank


=IF((ISBLANK(K1637)),"000000000e",MAX(A2:A6000)+1)

This should work but

Some rows have been deleted so the sequence is wacky

I cant copy this into the cells without all the reference changing .. wacky again

I need the blank rows to go to the end of a sort ascending (thats what the 00000000e is all about) but that doesnt always work

And I would really like the ability for a number to be entered manually into a cell.. and for the formula to work if the number is removed ... no thats too wacky

Sorry folk .. I seem to be working most of the projects bit out .. there is just a couple to go

assume you have 5 rows of data so A5 = 5

In A6 put =if(b6="","",a5+1)

copy down in column A and when you enter data, next sequential number appears in column A