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
[Solved] Calc Script looking for missing fields in columns
[Solved] Calc Script looking for missing fields in columns
- Attachments
-
- example.ods
- (11.42 KiB) Downloaded 128 times
Last edited by fgiorgio2 on Wed Sep 20, 2017 12:12 pm, edited 1 time in total.
OpenOffice 4.1.2 on Windows 10
Re: Calc Script looking for missing fields in columns
You have a spreadsheet.
A spreadsheet is a simplified programming language.
Use it.
A spreadsheet is a simplified programming language.
Use it.
- Attachments
-
- example2.ods
- lookup missing values
- (26.03 KiB) Downloaded 133 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
