Piny系列-剪刀石頭布

piny

題目
ABC三列僅為剪刀石頭布，不會有其他字，不會有空格
E2填入公式，可下拉

當結果可找出唯一勝方，則顯示之，否則顯示平手
請看D列之模擬答案(不得引用)

要求
無VBA
無定義名稱
無輔助列
若擴展成十列，公式字數大抵不會增加太多

出個小題消遣一下，正確答案者給予財富獎勵 ^^

准提部林

下班了, 先頂一個:
=INDEX({"布","石頭","剪刀","平手"},MIN(4,FIND(SUM((1-ISNA(MATCH({"石頭","布","剪刀"},A2:C2,)))*{1,2,4}),3561247)))

Chip_Kenny

試一下
=LOOKUP(--(IF(COUNTIF(A2:C2,"布"),1,"")  & IF(COUNTIF(A2:C2,"石頭"),2,"") & IF(COUNTIF(A2:C2,"剪刀"),3,"")),{1,12,13,23,24},{"平手","布","剪刀","石頭","平手"})

准提部林

再頂一個：
=MID(" 石頭平手剪刀布",MODE(SUM((COUNTIF(A2:C2,{"石頭","布","剪刀"})>0)*{2,4,1})-2,1,3,4,2,2)*2,2)
　
　

dgerwin

自知字元太多，但没有想到其他办法了。
Piny系列-剪刀石頭布.rar (8.25 KB, 下载次数: 6)

2017-3-8 20:51 上传

点击文件名下载附件

,=LOOKUP(SUM(MATCH(A2:C2,{"剪刀","石頭","","","布"},0)),{3,4,5,6,7,8,9,11,12,15},{"平手","石頭","石頭","平手","剪刀","平手","布","剪刀","布","平手"})

sqrall900

=IFERROR(LOOKUP(MATCH(3,MMULT(N(N(COUNTIF(A2:C2,{"剪刀","石頭","布"})>0)={1,1,0;1,0,1;0,1,1}),{1;1;1}),),{1,2,3},{"石頭","剪刀","布"}),"平手")
=IFERROR(INDEX({"布","剪刀","石頭"},MATCH(,(COUNTIF(A2:C2,A2)=3)+COUNTIF(A2:C2,{"剪刀","石頭","布"}),)),"平手")

猫头鹰的喵

=CHOOSE(MOD(SUMPRODUCT(1/COUNTIFS(A2:C2,A2:C2)),2)+1,IF(SUM(LEN(A2:C2))=6,"石頭",IF(COUNT(FIND("刀",A2:C2))>0,"剪刀","布")),"平手")
顶一个。顺便学习其他大师

sayhi95

1. =INDEX({"剪刀","平手","布","平手","石頭","平手"},SUM(ISNA(MATCH({"石頭","剪刀","布",1},A2:C2,))*{-1,1,3,2}))

复制代码

e表格学习

1. =IF(OR(AND(A2<>B2,B2<>C2,C2<>A2),AND(A2=B2,B2=C2)),"平手",IF(SUM(--(A2:C2<>"布"))=3,"石頭",IF(SUM(--(A2:C2<>"剪刀"))=3,"布","剪刀")))

复制代码

E2单元格输入上述三键结束的数组公式,然后下拉.
Piny系列-剪刀石頭布.zip (9.39 KB, 下载次数: 4)

2017-3-9 08:51 上传

点击文件名下载附件

上述解法只是比较直观的"普通"解法.本人认为还有更加简洁的"标准"解法,正在研究中.

shaowu459

1. =IF(SUM(1/COUNTIF(A2:C2,A2:C2))-2,"平手",INDEX({"布","剪刀","石頭","布"},MATCH(1=1,ISNA(MATCH({"剪刀","石頭","布"},A2:C2,)),)))

复制代码

最不擅长构造数字关系的了，出一个普通直白的思路