在Google工作表的两个标签中识别相同的单词 [英] To identify same words in two tabs in a google sheet

问题描述

我的查询是我想突出显示工作表中两个选项卡中的重复项.我的工作表随这个问题附上.在该表A"中， & "Sheet B"我有一个共同的名字，我想给重复的东西涂上颜色.

My Query is i want to highlight the duplicates in the two tabs in a sheet. My sheet is attached along with this question. In that "Sheet A" & "Sheet B" have common names in it i want to color it for the duplicates.

表格: https://docs.google.com/spreadsheets /d/1hL64Q7REorVkjJNKAEGPFBdinlIn8VwnE6H7L9fYB2c/edit#gid = 0

如果有可能，是否可以选择在两个Google工作表之间查找重复项? 如果是，那么请帮助我在比赛1的工作表A和比赛2的工作表C中查找重复项.

If it is possible, is there any option to find the duplicates between two google sheets ? if yes then pls help me to find duplicates in Sheet A in Match 1 sheet and Sheet C in Match 2 Sheet.

第二页: https://docs.google.com/电子表格/d/1xAUmvmaZPvfJwCHD_esrshLccgKM3VmP1CI46mMoRB8/edit#gid = 0

推荐答案

我有一个答案，显示了如何做到这一点.请参阅我在工作表中添加的标签"Sheet 1-GK". C1中的公式查看工作表2中的数据，以查看是否在工作表2中找到工作表1列A中的每个名称. 这是主要公式:

I have an answer that shows how this can be done. See the tab I added, "Sheet 1-GK", into your sheet. The formula in C1 looks at the data from Sheet 2 to see whether each name in Sheet 1 column A is found in Sheet 2. Here is the primary formula:

=ARRAYFORMULA(IFERROR(
IF(MATCH(A2:A9,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1xAUmvmaZPvfJwCHD_esrshLccgKM3VmP1CI46mMoRB8/edit","'SHEET C'!A$2:A$8"),0),
    "Y",
    "N"),
  "N"))

在工作表中，我将其包装在一个数组{...}中，还添加了列标题文本.

In the sheet, I have wrapped it in an array, {...}, to also add the column header text.

然后使用条件格式设置规则来突出显示具有"Y"的行.在C列中.

Then a conditional formatting rule is used to highlight the rows that have "Y" in column C.

请注意，您可以隐藏C列，或将其公式逻辑合并到条件格式设置规则中，以在那里执行所有操作.

Note that you can either hide column C, or incorporate its formula logic into the conditional formating rule, to do everything there.

这是您要找的东西，还是您需要其他东西?

Is this what you were looking for, or did you need something else?

这篇关于在Google工作表的两个标签中识别相同的单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！