Page 1 of 1

[Solved] Calc Script looking for missing fields in columns

PostPosted: Wed Sep 20, 2017 11:15 am
by fgiorgio2
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

Re: Calc Script looking for missing fields in columns

PostPosted: Wed Sep 20, 2017 11:36 am
by Villeroy
You have a spreadsheet.
A spreadsheet is a simplified programming language.
Use it.

Re: Calc Script looking for missing fields in columns

PostPosted: Wed Sep 20, 2017 12:10 pm
by fgiorgio2
Thank you :bravo: :bravo: