Excel Compare

[blackcobra]

I have an excel file.. 2ith 40000 rows and 50 Coulmns in a single sheet..

50 Columns are divided as 25 for Source and 25 Destination

Ex :

ADestination BDestination CDestination DD ED FD......ZD ASource BSource CSource DSource ...... ZSource

1 1 2 3 4 5 6 26 1 3 2 6 30
2
3
4
.
.
.
40000


Now, I need to compare ADestination with ASource
BDestination with B source
.........................................................................
ZD with ZS
Is there any software to do this and prepare a report of the same.

Or may be I can copy ADestination .. ZD on one Excel and ASource to ZS on to different excel and compare both the files.. is there any good Software to do the same..

[estrangeredgenius]

Really interesting , what project are you working on ...

If output is what matters , you could code a simple matrix
program using c/c++ for doing the same . But to input these
much values is tough task .

[grr]

blackcobra, pls c the 2 replies on the other forum u asked this question..

[blackcobra]

sorry grr and estrangeredgenius , I would explain it proper way this weekend...

Sorry my bad..

[grr]

sorry grr and estrangeredgenius , I would explain it proper way this weekend...

Sorry my bad..

No problem..

[Odie]

I'm sure you will be able to do the required comparison with the functions provided in Excel. If you can give me a download link to the file, I'll see what I can do.

[blackcobra]

sorry for the delay...

We are product based company where we collect Supplier Info and store it in out MAster DB
We collect data from different sources, cleanse, scrub the data and feed the data back to our Master DB.

Recenlty , people have gone bit lazy and there are huge variances in collected , cleased and Master DB.
I decided to dedicate myself to check what is being cleansed and loaded.I compare the data collected with the cleansed data. iff I find any variance, I prepare a report send it to the data team which does the collection and cleansing.After I get back the corrected data . I check the corrected file and give a nod for it to be laoded to Master DB.After the data is loaded back to the Master Db , I compared the cleansed data with the master DB to check if the data has been loaded properly ( checking the format , junk character etc etc ).

Coming back to my question, during the process of checking the collected data with the cleansed data ( this is in Excel format and there are thousands of record in the excel file with 118 rows of source and 118 rows of destination total 236 rows)

I have to compare the source columns with the destination columns.This I have to do it on daily basis for thousands of records.... what is the best possible way.


Attaching a sample of the document and is password protected.
Odie , estrangeredgenius,Grr will PM u the password of the file.

[grr]

blackcobra,

i advice u to delete this part of ur post above;

Removed quoted text

Sharing the above info is against professional ethics...