Hi, sorry in advance for probably stupid question, but I did not find any clear reference for such simple task (daughter needs help for school exercise):
1.
I have “Start” in A1
I have “End” in A2
I have ”Increment” in A3
I need to fill dynamic number of rows in column C with values from “Start” up to “End“ with “Increment”
Examples:
1) A1=1 A2=10 A3=1 -> 10 rows filled in column C (C1=1, C2=2, C3=3, C4=4, C5=5, C6=6, C7=7, C8=8, C9=9, C10=10)
2) A1=5 A2=10 A3=1 -> 5 rows filled in column C (C1=5, C2=6, C3=7, C4=8, C5=9, C6=10)
3) A1=1 A2=10 A3=4 -> 3 rows filled in column C(C1=1, C2=5, C3=9)
Etc.
2.
I need to fill dynamic number of rows in column D with values based on function from dynamic range in column C. Let’s assume D=2*C, then for above mentioned examples:
1) A1=1 A2=10 A3=1 -> 10 rows filled in column D (D1=2, D2=4, D3=6, D4=8, D5=10, D6=12, D7=14, D8=16, D9=18, D10=20)
2) A1=5 A2=10 A3=1 -> 5 rows filled in column D (D1=10, D2=12, D3=14, D4=16, D5=18, D6=20)
3) A1=1 A2=10 A3=4 -> 3 rows filled in column D(D1=2, D2=10, D3=18)
Etc.
3.I need to visualize it (plot a graph D(C)), so that entire graph is visible
Questions:
1.Is it possible without VBA?
2.If possible some hints/examples/links
Thanks
Bookmarks