查找列中是否存在值 [英] Find if value exists in column

问题描述

如何扩展功能以检查新电子邮件是否已在F列中存在?

How can I extend my function to check if the new email already exists in column F?

function emailUpdate() {
  var ss = SpreadsheetApp.getActiveSheet();
  var emailRow = ss.getRange("F2:F").getValues(); 
  var emailRowNum = emailRow.filter(String).length + 1;

  var emailNew = ss.getRange("F"+emailRowNum).getValues();
  return emailNew;}

所以我有一个Googlesheet，其中的电子邮件保存在F列中.我试图将最后一行的值(emailNew)与F列中的所有先前值进行比较，但是我不确定该怎么做...

So I have a googlesheet with emails saved in column F. I am trying to compare the last row value (emailNew) with all previous values in column F but I'm unsure how to do that ...

推荐答案

将范围中的最后一个值与所有先前的值进行比较.

Comparing the last value in a range with all of the previous values.

function comparelastvalue()
 {
   var ss=SpreadsheetApp.getActive();
   var sh=ss.getActiveSheet();
   var lastRow=sh.getLastRow();
   var rg=sh.getRange(2, 6, lastRow, 1);
   var vA=rg.getValues();
   var theseRowsEqualTheValueInTheLastRowA=[];
   for(var i=0;i<lastRow-2;i++)
   {
     if(vA[i][0]==vA[lastRow-1][0])
     {
       theseRowsEqualTheValueInTheLastRowA.push(i+2);
     }
   }
 }

这篇关于查找列中是否存在值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！