尝试使用脚本交叉检查Google Sheets中的两个范围

function crossCheckRanges() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range1 = sheet.getRange("范围1");
  var range2 = sheet.getRange("范围2");
  
  var values1 = range1.getValues();
  var values2 = range2.getValues();
  
  var duplicates = [];
  var missing = [];
  
  // 检查重复项
  for (var i = 0; i < values1.length; i++) {
    for (var j = 0; j < values2.length; j++) {
      if (values1[i][0] === values2[j][0]) {
        duplicates.push(values1[i][0]);
        break;
      }
    }
  }
  
  // 检查缺失项
  for (var i = 0; i < values1.length; i++) {
    var found = false;
    for (var j = 0; j < values2.length; j++) {
      if (values1[i][0] === values2[j][0]) {
        found = true;
        break;
      }
    }
    if (!found) {
      missing.push(values1[i][0]);
    }
  }
  
  // 输出结果
  if (duplicates.length > 0) {
    Logger.log("重复项: " + duplicates.join(", "));
  } else {
    Logger.log("没有重复项。");
  }
  
  if (missing.length > 0) {
    Logger.log("缺失项: " + missing.join(", "));
  } else {
    Logger.log("没有缺失项。");
  }
}