rennb - 経済統計練習帳

var code=new Array();
var title=new Array();
var dic=new Array();
var t=new Array();
 
function myFunction() {
 
id="1VjCi0k-98P_3YmlHyHb3up0zPl9mp1tbYsJUJxmqegg";
 
var ex1 = SpreadsheetApp.openById(id); 
var sheet = ex1.getSheetByName("data"); 
 
  number=sheet.getLastRow()-1; 
 
  var v=sheet.getRange(1,1,number+1,12).getValues()
 
for(s=1;s<number+1;s++){
code[s]=v[s][9];
title[s]=v[s][7];
}
 
 dicnumber=0;
 
  for(s=1;s<number+1;s++){ 
    c1=""+code[s]; 
    h=0; 
    for(sx=0;sx<dicnumber+1;sx++){ 
    if(c1==dic[sx])h=100; 
  } 
  if(h<50)dicnumber=dicnumber+1 
  if(h<50)dic[dicnumber]=c1; 
  if(h<50)t[dicnumber]=title[s] 
  } 
 
Logger.log(dicnumber);
 
 
}