Google表格-将一个单元格中的多个单词与另一个单元格进行比较，计算比赛次数

分类: 技术问答 • 2022-07-20 17:48:15

问题描述：

如果单元格A1包含兄弟姐妹父亲母亲孙子"，而单元格A2包含母亲父亲母亲"，则在单元格A3中返回2.

If cell A1 contains "Brother Sister Father Mother Grandson" and cell A2 contains "Mother Father", return 2 in cell A3.

我该如何实现?

答

尝试

=SUMPRODUCT(TRANSPOSE(SPLIT(A1," "))=SPLIT(A2," "))