google app script column to array indexof

Solutions on MaxInterview for google app script column to array indexof by the best coders in the world

showing results for - "google app script column to array indexof"
Willard
06 Feb 2019
1//  Google app script column to array indexOf
2var numRows = sheet.getLastRow();
3var nameRng = sheet.getRange(2, 3, numRows).getValues(); // this is [[v1],[v2],...
4var nameArr = String(nameRng).split(",");   // force column range into a String() and then split() it back into an array
5if (nameArr.indexOf(inName) > 0 )