A列到B列的重复值- Google Apps脚本

function findDuplicates() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var rangeA = sheet.getRange("A1:A" + sheet.getLastRow());
  var rangeB = sheet.getRange("B1:B" + sheet.getLastRow());
  var valuesA = rangeA.getValues();
  var valuesB = rangeB.getValues();
  var duplicates = [];

  for (var i = 0; i < valuesA.length; i++) {
    for (var j = 0; j < valuesB.length; j++) {
      if (valuesA[i][0] === valuesB[j][0]) {
        duplicates.push(valuesA[i][0]);
        break;
      }
    }
  }

  if (duplicates.length > 0) {
    Logger.log("重复值: " + duplicates.join(", "));
  } else {
    Logger.log("没有重复值。");
  }
}