excel - Automated Creation of Sequential Date/Number Range from Singular Numerical Value -


i'm attempting create sheet enter singular numerical value (0-##) , singular date in column a, , columns c , d populate sequential number , date extend far numerical value is.

enter image description here

in cell c1 enter following formula

=if(row()<=$a$2,row(),"") 

then in cell d1 enter

 =if(isnumber(c1),$a$4+(row()-1),"") 

or

=if(c1<>"",$a$4+(row()-1),"") 

drag/copy down formula required. next time on when you'll change values in cell a2 , cell a4, column c , column d populate values accordingly. see image reference.

enter image description here


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -