< Go Back

Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

in column a i want to input 1 2, 1 3, and then drag down to get 1 4, 1 5, 1 6,,.....and so on. I want to do the same for 2 3, 2 4.

Solved by Z. C. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert 03/05/2017 - 06:19
Hi, Welcome to Excel Chat
User 03/05/2017 - 06:19
hi
Excelchat Expert 03/05/2017 - 06:19
Please share the Excel File with Me
User 03/05/2017 - 06:19
i couldnt do one
Excelchat Expert 03/05/2017 - 06:20
Ok wait a minute
Excelchat Expert 03/05/2017 - 06:21
[Uploaded an Excel file]
Excelchat Expert 03/05/2017 - 06:21
Please Paste your data in the Sheet
User 03/05/2017 - 06:23
ok it did it in this chart
Excelchat Expert 03/05/2017 - 06:23
Ok Now tell me What should I do next ?
User 03/05/2017 - 06:23
but it didnt do it in excel on my home computer
User 03/05/2017 - 06:24
i was trying to do the same thing only starting with 2's
Excelchat Expert 03/05/2017 - 06:24
I think Your problem is resolved in this Sheet :)
Excelchat Expert 03/05/2017 - 06:25
Is it?
User 03/05/2017 - 06:25
yes
User 03/05/2017 - 06:25
can you do lottery numbers in excel
Excelchat Expert 03/05/2017 - 06:25
Please Upgrade your Microsoft Excel on your Computer
User 03/05/2017 - 06:25
ok
Excelchat Expert 03/05/2017 - 06:25
It would work there too then
Excelchat Expert 03/05/2017 - 06:26
Yes
User 03/05/2017 - 06:26
could you hold on a minute i want to try these numbers in my excel
Excelchat Expert 03/05/2017 - 06:26
Ok
Excelchat Expert 03/05/2017 - 06:29
Is it Working on your Computer ?
User 03/05/2017 - 06:30
its not working on my computer
Excelchat Expert 03/05/2017 - 06:31
Which Excel version you are using?
User 03/05/2017 - 06:31
i downloaded a trial version
User 03/05/2017 - 06:31
it should be 2017
Excelchat Expert 03/05/2017 - 06:32
[Uploaded an Excel file]
Excelchat Expert 03/05/2017 - 06:33
Please open this Document on your Computer
User 03/05/2017 - 06:33
ok
Excelchat Expert 03/05/2017 - 06:33
and Try working on this Document
Excelchat Expert 03/05/2017 - 06:35
Did it worked out ?
Excelchat Expert 03/05/2017 - 06:36
Our Session time is about to end; Please let me if it worked out or not
User 03/05/2017 - 06:36
i dont understanfd what to do
Excelchat Expert 03/05/2017 - 06:36
Please Try using Full Version of Microsoft Excel 2007 or 2010 or 2013
User 03/05/2017 - 06:37
ok
Excelchat Expert 03/05/2017 - 06:37
Type 20 and 21 and then Drag the Column downwards
Excelchat Expert 03/05/2017 - 06:37
I hope it worked with full version of Excel
User 03/05/2017 - 06:38
didnt work
Get instant expert help with Excel and Google Sheets

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

Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.