Hi,
I am trying to compare 2 Excel worksheets in 2 different Excel Files.
And i haev come across a unique situation where due to some reason Beyond Compare is unable to identify that 2 rows in the 2 files are same and it highlights them as RED, even inspite of teh fact that the 2 rows are matching. I have specified the 2 rows below. They are exactly similar. I have also tried to do an Excel Conditional Formating to confirm if there was any spaces or something between teh 2 rows of teh 2 files but that is not the case.
2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE
2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE
Does any one have any clue as to how could i make BC identify teh 2 rows as same and not flag them as RED?
Appreciate your immediate response as i am stuck sicne a while!!!
Thanks in advance
Hitesh
I am trying to compare 2 Excel worksheets in 2 different Excel Files.
And i haev come across a unique situation where due to some reason Beyond Compare is unable to identify that 2 rows in the 2 files are same and it highlights them as RED, even inspite of teh fact that the 2 rows are matching. I have specified the 2 rows below. They are exactly similar. I have also tried to do an Excel Conditional Formating to confirm if there was any spaces or something between teh 2 rows of teh 2 files but that is not the case.
2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE
2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE
Does any one have any clue as to how could i make BC identify teh 2 rows as same and not flag them as RED?
Appreciate your immediate response as i am stuck sicne a while!!!
Thanks in advance
Hitesh
Comment