Question description:
This user has given permission to use the problem statement for this
blog.
Hi, I wish to create a chart which row a, column a is say a value of 5, row b column a is a value of 5, but row c column a is a value of 6 (incrementing every 2 cells)
Solved by E. L. in 4 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
29/05/2018 - 10:37
Hi
Excelchat Expert
29/05/2018 - 10:37
Hi there!
User
29/05/2018 - 10:37
Thank you for the help
Excelchat Expert
29/05/2018 - 10:37
I can automate that for you
Excelchat Expert
29/05/2018 - 10:37
I will create the same in column B so you can see
User
29/05/2018 - 10:37
perfect
Excelchat Expert
29/05/2018 - 10:38
you would only have to enter the first number in cell B1
User
29/05/2018 - 10:38
exactly
Excelchat Expert
29/05/2018 - 10:39
Does that give what you need?
User
29/05/2018 - 10:39
yep
Excelchat Expert
29/05/2018 - 10:39
Awesome!
Excelchat Expert
29/05/2018 - 10:39
Please don't hesitate to ping us back with a new session if you need more assistance.
User
29/05/2018 - 10:39
so how did u do that
User
29/05/2018 - 10:39
lol
Excelchat Expert
29/05/2018 - 10:39
Oh can you see the formulas in there?
User
29/05/2018 - 10:40
ohhh
User
29/05/2018 - 10:40
smart i see what you did
Excelchat Expert
29/05/2018 - 10:40
The first row just = the cell above
Excelchat Expert
29/05/2018 - 10:40
then the second cell adds 1
Excelchat Expert
29/05/2018 - 10:40
and this repeats!
Excelchat Expert
29/05/2018 - 10:40
easiest way I could think of.
User
29/05/2018 - 10:40
awesome thank you !!
User
29/05/2018 - 10:40
will def reccomend
Excelchat Expert
29/05/2018 - 10:40
:) thanks so much.
Excelchat Expert
29/05/2018 - 10:40
All the very best and have a great day ~
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.