Comparing 4 xls files and removing duplicates?

Question

PHP

Hello!
The question is:
There are 4 or more Excel files, all of them have one column with the number of payment
And there is 5 file general, where there are all payments from these 4 files, plus which are not there, you need to get the 6th file with deletion from 5 5- th file of lines that are in the first 4
Maybe someone is aware of some kind of software for comparing and deleting superfluous, or maybe someone saw Php articles on writing such a parser.
I will also consider who can do it, not for free of course.

Answer 1

1. From all files in 1 column, collect the payment number (for example, in column A)
2. In a column (for example, C) copy the resulting list.
3. Select column C - Data tab - Delete Duplicates
thus. we get a list without duplicates
4. In column D we write the formula (for cell D2) =COUNTIF(A:A;C2), Where A:A is the column of all payment numbers (with duplicates), C2 is the payment number without a double. And stretch the formula down
5. In column D, set the value filter =1 (because we need to get a list of payments that are only in file No. 5, these are the payments that take values ​​in paragraph 4 only 1).
6. Further, the list obtained in paragraph 5 is transferred to file No. 5 and we obtain the corresponding lines from them.
It's really convenient for the soul Index / VLOOKUP / GLOOKUP and other Excel BDSM toys

Answer 2

Instead of it is easier to make through CSV? Without BDSM practically. With the same Notepad++, even alternately compare 5+1=6upd, 6+2=6upd, 6+3=6upd, 6upd+4=6final , of
course, parsing is cooler than a thread, but IMHO you can use such a crutch for such a task.