如果一行中的3个单元格在另一行中相等，则返回文本 [英] Return text if 3 cells in a row are equal in another row

问题描述

我想问问是否有一种方法可以返回文本，如果一行中恰好3个单元格等于另一行中另外3个单元格.

I would like to ask if there is a way to return text if exactly 3 cells in a row are equal to another 3 cells in another row.

我希望它看起来像的例子.

Example of how I want it to look like.

推荐答案

您可以尝试以下公式:

=IF(COUNTIFS(A:A,A1,B:B,B1,C:C,C1)>1, "ERROR", "OK")

COUNTIFS(A:A，A1，B:B，B1，C:C，C1)计算一系列单元格A1，B1和C1在A列中出现的次数，B和C.

COUNTIFS(A:A,A1,B:B,B1,C:C,C1) counts the number of times a series of cells A1, B1 and C1 appear in the columns A, B and C.

如果大于1(大于1)，则输入 ERROR ，否则输入 OK .

If it's above 1 (there's more than one), put ERROR, else OK.

这篇关于如果一行中的3个单元格在另一行中相等，则返回文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！