Previous Topic Next Topic

Replace column with other column then delete

Closed
chandulal Posts 4 Registration date Monday March 1, 2010 Status Member Last seen March 4, 2010 - Mar 3, 2010 at 11:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 08:39 AM
Hello,
Respected Seniors and friends,
Feeling proud here among You ALL
Happy Holi
Holi is an auspicious festival of India.
I’m not good in English so please bear with me,
I attached picture of my query here named Chandus problem.png . Please help.

(1) I have an excel file
(2) The File has 9 columns viz,
COL A, COL B, COL C, COL D, COL E, COL F, COL G, COL H, COL I
(3) COL A includes Name entries
(4) COL H also includes Name entries.
(5) All Names of COL H are in COL A but,
All Names of COL A are not in COL H
(6) COLUMNS B, C, D, E, F, G and I have numerical data but,
COL I has data corresponding to COL H’s Names and COL H has Names
among majority Names are present in COL A.

What I want,

I want to Merge (Replace) all entries of COL H into COL A and then delete COL H.
So, COL I becomes COL H.
Want, To set entries of COL I (now COL H) against corresponding Replaced entries of COL A.
Want to allot value ZERO (0) in COL H, against entries of COL A which are not replaced by entries of COL H

Thanks in advance,
Yours,
Chandu

2 responses

Answer 1 / 2
chandulal Posts 4 Registration date Monday March 1, 2010 Status Member Last seen March 4, 2010
Mar 3, 2010 at 11:11 AM
Hello Friends,
I can not attach Picture file and excel file regarding to my problem. How can I do it? Please help me for manage attachment in forum's question.
Thanks,
Chandulal
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 3, 2010 at 11:38 AM
Attach it on a share site and then post the link
https://authentification.site

You can use VLOOKUP

in Cell J2 (assuming your data starts at row 2) write

=IF(ISERROR(VLOOKUP(A2, H:I,2, FALSE)), 0, VLOOKUP(A2, H:I,2, FALSE))
Drag this formula down to the last row of your data

Select COl J and do copy and then paste special and choose values. Now you can delete the H and I columns as this new column is what you wanted
0
chandulal Posts 4 Registration date Monday March 1, 2010 Status Member Last seen March 4, 2010 > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Mar 3, 2010 at 11:28 PM
Respected Rizvisa1,
I think you could not understand my problem due to my poor english
What I want is described in attached files at speedyshare.
Thanks for showing sharing site speedyshare site.
I have attached Image, Excel and Description files regarding my query. U can understand well after looking them.
The Links are as below:
http://www.speedyshare.com/files/21248143/Chandus_problem.png
https://authentification.site/files/21248147/ChandusProblem.xls
https://authentification.site/files/21248149/Chandu_Problem.doc
Thank you sir for reply,
Awaiting for more guidence
Yours,
chandulal
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > chandulal Posts 4 Registration date Monday March 1, 2010 Status Member Last seen March 4, 2010
Mar 4, 2010 at 06:11 AM
But it is exactly as I said.

http://www.speedyshare.com/files/21249959/snap.jpg

I have not not done, the part of copy and paste special to show you how in newly created column K the values are as you wanted.

If I do copy and paste special as values in column K and delete column H and I and J. How it will look different from what you have
0
Answer 2 / 2
chandulal Posts 4 Registration date Monday March 1, 2010 Status Member Last seen March 4, 2010
Mar 4, 2010 at 08:27 AM
Respected Rizvisa1 Sir,
You Done it. Exactly which I want.
Actually I paste formula in first line so I confused but now OK.
Thank you very very much sir,
I Pray for Blessings of Almighty God upon you and your family forever.
thanks again sir
yours,
Chandu
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2010 at 08:39 AM
Thanks for good wishes. Same to you
0

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses