这个EXCEL的问题怎么弄?谢谢!

来源：百度知道 编辑：UC知道 时间：2024/05/26 12:42:41
a b c
1 2 3 c
1 1 1 持平
2 2 3 C
3 3 2 A B
如上面显示! 取三个数中最大的一个显示列! 如果三个数字都相等则显示持平,如果两个相等显示两个的列号!

D1输入=IF(AND(A1=B1,B1=C1),"持平",IF(AND(A1=B1,B1>C1),"AB",IF(AND(A1<=B1,B1<C1),"C",IF(AND(A1<B1,B1=C1),"BC",IF(AND(A1>B1,B1>=C1),"A",IF(AND(A1<=C1,C1<B1),"B",IF(AND(A1=C1,C1>B1),"AC",(AND(A1>C1,C1>=B1,"A")))))))))
下拉

d1=IF(COUNTA(A1:C1)<3,"",IF(COUNTIF(A1:C1,MAX(A1:C1))=1,CHAR(64+MATCH(MAX(A1:C1),A1:C1,0)),IF(COUNTIF(A1:C1,MAX(A1:C1))=2,CHAR(64+MATCH(MAX(A1:C1),A1:C1,0))&CHAR(64+SUMPRODUCT((MAX((A1:C1=MAX(A1:C1))*COLUMN(A1:C1))))),"持平")))