五格同時重复 (9557)


F3=IF(COUNTIFS(A:A,A3,B:B,B3,C:C,C3,D:D,D3,E:E,E3)=1,"唯一行","有重复行")


另解=IF(SUM(N(MMULT(N(A$3:E$7=A3:E3),{1;1;1;1;1})=5))>1,"有重复行","唯一行")


留言