compare some text in columns in two excels

November 29, 2011 at 19:29:40
Specs: Windows XP
I have two sheets in that

Sheet 1 Column A is TT NUMBER(It should be 15digit) and in B Column Fault Description with respective TT Number(It text like BTS-172 down in khanpur cluster).

Sheet1 data is Manually updated data

In sheet2 (Server Data)
Column A TT NUMBER(which is 15digit) and in B Column Fault Description with respective TT Number(It text like BTS-172 down in khanpur cluster).

Sheet2 data is Server data.

1. Some times in sheet1 Manual data updating Wrong TT NUMBER and same TT Number for Different Fault Discriptions(Fault Discription not coming exact in two sheets but it will match some data).This thing i have to compare with sheet2 server data and i need exact result for TT Number and Description.


Sheet 1 Information

Event Description TT NUMBER


BTS-64(Trichy_road_Gh) down in Coimbatore Cluster TT0000000537636
2 BTS-231,113(Kosgi,Mantralayam) are down in T&R Cluster TT0000000537636
5 BTS-358,406,448,409,340 are Fluctuating in Bangalore Cluster TT0000000537806
BTS-1742(Panashil) down in Kolkata Cluster TT0000000537658
BTS-1375(Bishnupur) down in Kolkata Cluster TT0000000537748
BTS-1696(Sealdah_02) down in Kolkata Cluster TT0000000537766
BTS-1511(CHINSURAH) down in Kolkata Cluster TT0000000537782
BTS-1565(Ichapur-Majherpara) down in Kolkata Cluster TT0000000537783
BTS-1223(Kumirlapara) down in Kolkata Cluster TT0000000537862

Sheet2 Information

Fault Description TT NUMBER
TEST TT TT0000000537924
BTS-23(LAKSHMI NAGAR) down in Jorhat Cluster TT0000000537683
BTS-103(Sairang) down in MIZORAM Cluster TT0000000537861
BTS-1223(Kumirlapara) down in Kolkata Cluster TT0000000537862
2 BTS-261,226(WB_GOSABA,WB_BASANTI) are down in Joynagar Cluster TT0000000537745
BTS-1435(PIRHAT) down in Bhadrak Cluster TT0000000537716
BTS-256(MOHANIA) down in Sasaram Cluster TT0000000537850
KO-BTS-1565(Ichapur-Majherpara) down in Kolkata Cluster TT0000000537783
BTS-97(WB_TADONG_01 ( GANGTAK_02)) down in Gangtak Cluster TT0000000537731
5 BTS-49,46,48,47,45 are down in MANIPUR Cluster TT0000000537969
TEST TT TT0000000537988
BTS-1970(WB_KHARAGPUR_10) down in Kharagpur Cluster TT0000000537912
TEST TT0000000537778
2 BTS-70,29 are down in MANIPUR Cluster TT0000000537980
BTS-1300(JALESWAR_02_KRISHNANAGAR) down in Balasore Cluster TT0000000537667
BTS-372(Dhansar) down in Dhanbad Cluster TT0000000537965
4 BTS-61,44,65,59 are down in Ranchi Cluster TT0000000537640
BTS-1742(Panashil) down in Kolkata Cluster,2 TT0000000537658
BTS-23(LAKSHMI NAGAR) down in Jorhat Cluster TT0000000537666


Please do the needful ASAP



See More: compare some text in columns in two excels

Report •


#1
November 30, 2011 at 05:36:01
Hi Narasimha,

it seems to me, your examples differ from your description of which columns are used for what.

Do you use one row only for each fault, and are they the same number row on each spreadsheet?

If yes to both, can you use the script language to compare the relevant TT cells on each row and flag if diifferent?

Good Luck - Keep us posted.


Report •

#2
November 30, 2011 at 08:24:30
It is impossible for us to tell what data you have in what columns.

Please click on the blue line at the end of this post and read the instructions found via that link. Then repost your data, including Column letters and Row numbers so that we can better understand the layout of your spreadsheet.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question