Hi all,

I'm currently trying to do some automatic processing of two CSV files.
What needs to happen is the following.

The CSV files come in on two weekly basis.
These need to be placed into two separate worksheets in Excel.

In the third and forth tab I want to see data that compares the information from the two CSV files.

One where it shows data that all the data that only shows up in CSV1
One where it shows data that all the data that only shows up in CSV2

Example

CSV1 CSV2 TAB3 TAB4
1 2 4 5
2 3 7
3 5
4 7

I currently have some rules like:
=IF(ISNA(MATCH('tab2'!C14,tab1!A:A,0)),'tab2'!C14,"") but it will keep the cells were they are
so tab 3 will end up looking with many empty cells

1


4

5

Anyone who has better idea on how to process this better?

Thanks!