Excel - auto number generation

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:27 PM GMT

Question

Auto Generated Number

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

Answer

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

©2017 eLuminary LLC. All rights reserved.