謝謝各位的參加,真心感謝不吝費心費力共享精心的公式.
最後還是將拙作提供參考,若有誤請指正:
<一>數組,107字:
=CHOOSE(MAX(COUNTIF(A2:C2,A2:C2)),SUM((A2+B2+C2={6,15})*{-1,10}),-TEXT(MODE(A2:C2)*2-A2-B2-C2,"[=-1]1"),10)
<二>數組.107字:
=LOOKUP(11,IF({1,0},SUM((A2+B2+C2={6,15})*{-1,10}),--TEXT(SUM((A2:C2<>MODE(A2:C2))*A2:C2),"[=]10;[=1]-1")))
<三>數組.104字:
=CHOOSE(OR(A2=B2:C2)+(B2=C2)+1,SUM((A2+B2+C2={6,15})*{-1,10}),-TEXT(MODE(A2:C2)*2-A2-B2-C2,"[=-1]1"),10)
<四>一般.120字:
=LOOKUP(11,CHOOSE({1,2,3},SUM((A2+B2+C2={6,15})*{-1,10}),-TEXT(MODE(A2:C2)*2-A2-B2-C2,"[=-1]1"),MODE(A2:C2,0,0,0)^0*10))
<五>一般.116字:
=LOOKUP(11,CHOOSE({1,2,3},SUM((A2+B2+C2={6,15})*{-1,10}),-TEXT(MODE(A2:C2)*2-A2-B2-C2,"[=-1]1"),10/(A2=B2)/(B2=C2)))
<六>數組.98字:
=LOOKUP(A2+B2+C2-MODE(A2:C2,8,8)*(2+AND(A2=B2:C2)),{-10,-9,-1,1,2,3,4,5,6},{-1,0,10,-1,2,3,4,5,6})
<七>一般,100字:
=LOOKUP(A2+B2+C2-MODE(A2:C2,8,8)*2-MODE(A2:C2,0,0,0),{-10,-9,-1,1,2,3,4,5,6},{-1,0,10,-1,2,3,4,5,6})
|