Fix 20-line Google script for Google Sheets

The 20-line Google script below is to remove all rows in Sheet1 one that in any column substring-match any value inside column A on Sheet2. It's not working correctly. When you run the script once, the row with the value "ccc" in Sheet1 is still there even though it "c" is one of the values inside column A in Sheet2. I'm looking for a fix to the script. I have $50 for this if you can turn this around in one hour.

Below is a link to a public sheet you can copy.




function onOpen() {

const ui = [login to view URL]();

[login to view URL]('Functions')

.addItem('Unsubscribe', 'est_unsubscribe')



function est_unsubscribe() {

var ss = [login to view URL]();

var unsubscribe=[login to view URL]("Sheet2");

var sheet = [login to view URL]();

var dataRange = [login to view URL]();

var values = [login to view URL]();

var lastrow=[login to view URL]();

var findvalue="";

for(var k=1;k<=lastrow;k++){

findvalue=[login to view URL](k,1).getValue().toString();

[login to view URL](findvalue);

for (var i = 0; i < [login to view URL]; i++) {

var row = "";

for (var j = 0; j < values[i].length; j++) {

if (values[i][j].toString().includes(findvalue)) {

row = values[i][j+1];

var increment=i;

[login to view URL](++increment) // This is your row number






Compétences : Google Sheets, Google Apps Scripts

Concernant le client :
( 110 commentaires ) Miami Beach, United States

Nº du projet : #32695633

Décerné à:

(7 Commentaires)

5 freelances font une offre moyenne de 44 $ pour ce travail

(23 Commentaires)
(15 Commentaires)
(6 Commentaires)

Hey, I can Fix your 20-line Google script for Google Sheets In how much time you want it to be completed?? Let's talk about your project Waiting for your response!!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)