Array Comparison Script for Google Sheets
Budget: $10 – $30 USD
I need a customized script that works within Google Sheets to continually scan for differences in an array. Specifically, I am interested in identifying both additions and deletions to the array. I need a custom google sheets script that is checking two different cells. Each cell has items SKUs as an array. For example Cell 1 has
XF11088, XF11088, VS11088, VS11088
I have a second cell that is importing scan data from google appsheet
The data for example could be VS11088. I need a script that compares cell 1 and 2 and tells me the differences. In my case the differences should be XF11088, XF11088, VS11088, as the cell 2 has a single scan of the VS11088
Scope:
• The script should be designed to actively check for differences at regular intervals, ideally every hour.
• Most importantly, the script must monitor the array for both additions and deletions, rather than solely one or the other.
Skills and Experience:
• Experience with Google Sheets scripting
• Knowledge of array management
• Coding skills for creating active formula scripts
Please note, at this time there's no requirement for additional functionalities like email notifications or auto-updating the array. The primary aim is the development of an efficient script to track additions and deletions in the array.
XF11088, XF11088, VS11088, VS11088
I have a second cell that is importing scan data from google appsheet
The data for example could be VS11088. I need a script that compares cell 1 and 2 and tells me the differences. In my case the differences should be XF11088, XF11088, VS11088, as the cell 2 has a single scan of the VS11088
Scope:
• The script should be designed to actively check for differences at regular intervals, ideally every hour.
• Most importantly, the script must monitor the array for both additions and deletions, rather than solely one or the other.
Skills and Experience:
• Experience with Google Sheets scripting
• Knowledge of array management
• Coding skills for creating active formula scripts
Please note, at this time there's no requirement for additional functionalities like email notifications or auto-updating the array. The primary aim is the development of an efficient script to track additions and deletions in the array.