< Go Back

Excel - COLUMN Function Problem - Expert Solution

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

I want to replace entire column............................................

Solved by B. B. in 40 mins

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

User 19/06/2018 - 05:04
hio
User 19/06/2018 - 05:04
hi
Excelchat Expert 19/06/2018 - 05:04
Hi Welcome to Got it Pro
Excelchat Expert 19/06/2018 - 05:05
Can you please share your excel sheet
User 19/06/2018 - 05:05
i cant
User 19/06/2018 - 05:06
it confientia;ll
Excelchat Expert 19/06/2018 - 05:06
Just create dummy data and share it with me
Excelchat Expert 19/06/2018 - 05:06
Its just for better understanding and results
User 19/06/2018 - 05:06
i just want to replace one column of one sheet witrh the similar column from the another sheet
Excelchat Expert 19/06/2018 - 05:08
Replace means.
Excelchat Expert 19/06/2018 - 05:08
do you have any unique Id?
Excelchat Expert 19/06/2018 - 05:10
Are you there with me?
Excelchat Expert 19/06/2018 - 05:10
If you want to replace just copy paste..
Excelchat Expert 19/06/2018 - 05:10
If you want to replace based on some unique Id you can use Formulas.
Excelchat Expert 19/06/2018 - 05:10
Request you to create some dummy data and share it with me so that will give better results
User 19/06/2018 - 05:13
hi
Excelchat Expert 19/06/2018 - 05:13
Are you there with me
User 19/06/2018 - 05:13
sorry i had to be away
Excelchat Expert 19/06/2018 - 05:13
No Problem
User 19/06/2018 - 05:14
ok.. now i have created dummy on the worksheet that ius deiplayed with chat window
Excelchat Expert 19/06/2018 - 05:14
is it Just minute
User 19/06/2018 - 05:14
can you see thta
Excelchat Expert 19/06/2018 - 05:14
Not yet. Can you send the sheet
User 19/06/2018 - 05:15
i m looking for share buttoin on tht
Excelchat Expert 19/06/2018 - 05:15
in your chat window there is a attachement icon
User 19/06/2018 - 05:15
how do i share tht
User 19/06/2018 - 05:15
ok
User 19/06/2018 - 05:15
thenm?
Excelchat Expert 19/06/2018 - 05:16
Just click and select the file
Excelchat Expert 19/06/2018 - 05:16
Or give me one minute let me refresh my page
User 19/06/2018 - 05:16
yupp
User 19/06/2018 - 05:16
coz i hv just created on this website.
Excelchat Expert 19/06/2018 - 05:16
Sure.Please hold on
User 19/06/2018 - 05:17
in this i want to replace col. B of sheet 1 with col. B off sheet 2
Excelchat Expert 19/06/2018 - 05:18
Just a minute
User 19/06/2018 - 05:18
k
Excelchat Expert 19/06/2018 - 05:20
Can you please check and confirm
Excelchat Expert 19/06/2018 - 05:20
Sheet1 Contains only 14 values but sheet2 contains more than 14 rows.
User 19/06/2018 - 05:21
yes
Excelchat Expert 19/06/2018 - 05:21
I just created New value in Column C ...
Excelchat Expert 19/06/2018 - 05:22
Please confirm whether result is correct or not
User 19/06/2018 - 05:23
k
User 19/06/2018 - 05:23
i can seee
Excelchat Expert 19/06/2018 - 05:23
Thank you. Waiting for your confirmation.
User 19/06/2018 - 05:23
it still does not solve
Excelchat Expert 19/06/2018 - 05:24
Yes. Please tell me your need let me solve it.
Excelchat Expert 19/06/2018 - 05:24
Sheet1 - There are around 14 values.
Excelchat Expert 19/06/2018 - 05:24
Copy of Sheet1 - There are around 23 Values
Excelchat Expert 19/06/2018 - 05:25
What kind of replacement you are expecting give me one example so that I will help you to solve
Excelchat Expert 19/06/2018 - 05:27
Are you there with me?
User 19/06/2018 - 05:28
ok
User 19/06/2018 - 05:28
how do i do in my sheeet
User 19/06/2018 - 05:28
sorry i m at work so get to be off in between
Excelchat Expert 19/06/2018 - 05:28
Ok..
Excelchat Expert 19/06/2018 - 05:29
Do you have two books or sheets?
User 19/06/2018 - 05:32
yupp
Excelchat Expert 19/06/2018 - 05:33
If you spend 5 minutes we will finish it quickly.
User 19/06/2018 - 05:33
two sheets but sht 2 is copied from sht 1, then edited and now I want a col. of sht 1 to be replaced with col of sht 2
Excelchat Expert 19/06/2018 - 05:35
I think there is no changes in first 15 rows in your sheet1 and copy of sheet1
User 19/06/2018 - 05:35
yupp.
User 19/06/2018 - 05:35
but what if sht s col. is changeed a lot
Excelchat Expert 19/06/2018 - 05:36
Please check sheet 1 result column C
Excelchat Expert 19/06/2018 - 05:36
It will be as per copy of sheet 1
User 19/06/2018 - 05:38
ok.. thanks for your help..
Excelchat Expert 19/06/2018 - 05:38
your welcome :)
Excelchat Expert 19/06/2018 - 05:39
If you want simple replace just copy paste
Excelchat Expert 19/06/2018 - 05:39
it will solve your issue or you can use this approach as well.
Excelchat Expert 19/06/2018 - 05:39
Create one column for SNo...(Column A) in both sheets and use vlookup function.
Excelchat Expert 19/06/2018 - 05:42
Are you there?

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 privacy is guaranteed. Your session will not be used for blog unless you give us persmission.