Apache OpenOffice Community Forum

Hello
I have 2 columns in Calc, A and B, with a list of data.
I would like to create a script that can take each field in Column A and look for it in Column B. If it finds it, nothing should happen. If it does not find it, it should write the missing field on a new column called "missing in column B".

And viceversa:
The script should take each field in the Colulmn B and look for it in Column A. If it finds it, nothing should happen. If it does not find it, it should write the missing field on a new column called "missing in column A".

Attached you can find the file with the Result I would like to get.

Please let me know your best quote for this script, I can pay by payPal.

Thanks
Francesco

You have a spreadsheet.
A spreadsheet is a simplified programming language.
Use it.

Thank you