worksheetssheet1.ranged

Hi. I am managing a datasheet in which subjects have taken a survey (only those under age 17). I wrote a script to fill the remaining blank cells (w/out data) with the value 999 if the participant either is not included in study (column 3 cell value = 0) or if their age is >= 18. The script runs...

Hi, I have two sheets with a list of data on each, both have ID codes for each row, but they don't always match: Sheet 1 should have all the codes but it also duplicates some, and the duplicates must be retained: Eg 1 2 2 2 3 3 4 5 6 7 7 8 9 [...] Sheet 2 doesn't have all the codes: 1 2 3 5 7...