Compare two excel columns

[Closed]
Report
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Hello,

I have two excel sheets. One has Server Names only.
Second has server names with other columns with more data like OS,Supplier,Application running.
1st sheet is imp and dont want to change or remove any severs.
I want to match 2nd sheet.If server if 1st sheet matches with server in 2nd sheet, i want to put all other columns in front of Server so I will have one list with all details
Please advice.avindia@gmail.com

1 reply

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!