Answer the question
In order to leave comments, you need to log in
Why doesn't indexof see the values in the value set from the column?
Hello.
I want to avoid repetitions when filling the table. To do this, you need to compare the incoming values with the values in the column. But indexof and lastindexof do not see values taken from a column of values in a set of values. Although they are there.
Code to get values from a column.
var ran = sheet1.getRange(2, 3, lr-1, 1);
var values = ran.getValues();
var firstIndex = values.indexOf(IntDocNumber);
var lastIndex = values.lastIndexOf(IntDocNumber);
Answer the question
In order to leave comments, you need to log in
https://developers.google.com/apps-script/referenc...
removeDuplicates()
you can finally just run the entire sheet through this method
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question