What I want is that all the data in CSV1 is compared with the data in CSV2 on record (row) level with the exception of some columns that are not needed and make every record unique. In the result sheet you can see which columns are needed and not needed.

So to make a summary:
- I import CSV1 to sheet1 and sort it by column A,B,F,G,H,I,K,L,M
- I import CSV2 to sheet2 and sort it by column A,B,F,G,H,I,K,L,M

Than in a third sheet I want both CSV's next to eachother (not every column only the ones that are in result sheet (see example).

He has to put the rows that are exactly the same next to eachother and set a value (e.g. equal) in a cell next to the compared record (new column). Also the third sheet should be sorted the same way as sheet 1 and 2. CSV1 or 2 can contain records that are not in the other CSV so an empty record next to it is expected in the third sheet with a result (e.g. new) next to it.

That's about it :-) Complex I think no ? Thanks for looking into my problem.