I am looking for a formula that will auto generate sequential numbers in a list starting at 2000. It would be based on the Header cell to its left when information is in the cell directly to that cells left. Make sense? See attached
So the new number needs to be specific? like the one above it, +1 ?
if so, something like this, assume the thing on the left is col C, and the numbers will need to be in col D.
=IF(LEN(C5)>0,D4+1,"")
or do you mean a random #, in that case use the same method about if length>0 , but use the RAND formula.
Advertisement