D2=CHOOSE(ISNUMBER(FIND(SUM(SMALL(MID(C2,{2,3,4},1)*1,{1,2,3})*10^{2,1,0}),"123456789"))+ISNUMBER(FIND(SUM(SMALL(MID(C2,{1,2,3,4},1)*1,{1,2,3,4})*10^{3,2,1,0}),"123456789"))*2+1,"一般","小順","大順","大順")
另解{=CHOOSE(MAX(FREQUENCY(IF(1-ISERR(FIND(ROW($1:$9),C2)),ROW($1:$9)),IF(ISERR(FIND(ROW($1:$9),C2)),ROW($1:$9)))),"一般","一般","小順","大順")
另解{=IF(SUM(ISNUMBER(FIND(MIN(MID(C2,ROW($1:$4),1)-1)+ROW($1:$4),C2))*1)=4,"大順",IF(SUM(ISNUMBER(FIND(MIN(MID(C2,{2,3,4},1)-1)+ROW($1:$3),C2))*1)=3,"小順","一般"))
留言
張貼留言