Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc