make comparison

Hi friends...

Please, help me and I am sory for my broken english...

I have two excel files.

I need to make comparison...

same data in each file, but different formats... but sometimes data is not the same.. I can't not find mistake where, because there are too many records...

If you look at the files will understand I wanted to...

thanks in advice...

You'll need to clean up file 1 a bit in order to make the comparison. First, use find / replace to change the commas (,) to periods (.) in colum "D".

Now all you have to do is trim the strings so they match file 2. Create new columns to capture the trimmed data.

For column b - get rid of the date at the end: use LEFT(B1,16)
For column c - get rid of the word "case" at the end: use LEFT(C1,LEN(C1)-4)*1
For column d - get rid of the word "KG" at the end: use LEFT(D1,LEN(D1)-2)*1

All this assumes the samples you sent are representative of the whole. But even if they are not, you can use these functions to get what you need.

Hope this helps

SAE