[已开][字符争霸第六期]：函数提取首个级别字母

砂海 · 发表于 2014-2-16 22:08

=CHOOSE(MIN(IF(COUNTIF(A11,{"*A*","*B*","*C*"})=1,{1,2,3},4)),"A","B","C","D")

参与一下,等开帖看高手

tgydslr · 发表于 2014-2-16 22:11

本帖最后由 tgydslr 于 2014-2-16 22:12 编辑

很遗憾，越来越长了

=UPPER(MID("dABCDabcd",MIN(IF(ISNUMBER(FIND(MID("ABCDabcd",ROW($1:$8),1),A2)),ROW($1:$8)))+1,1))

复制代码

笨熊猫 · 发表于 2014-2-16 22:26

本帖最后由笨熊猫于 2014-2-19 10:58 编辑

=UPPER(MID(A2&"D",MIN(SEARCH({"A";"B";"C"},A2&"ABC")),1))

46字符
=CHAR(69-MATCH(,-SEARCH({"","C","B","A"},A2)))

as0810114 · 发表于 2014-2-16 22:37

唉，突然赶脚不会函数了，难觉不爱啊。

=MID("AABBCCDD",MIN(IFERROR(FIND(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"AaBbCcDd"),8)),1)

复制代码

as0810114 · 发表于 2014-2-16 22:54

本帖最后由 as0810114 于 2014-2-16 22:58 编辑

取巧到底，含等号81

=MID("AABBCCDD",MIN(IFERROR(FIND(MID(REPT(A2,99),ROW($1:99),1),"AaBbCcDd"),8)),1)

复制代码

1091126096 · 发表于 2014-2-17 00:02

本帖最后由 1091126096 于 2014-2-24 00:40 编辑

不好意思，公式很长。分别为67，67，64,63, 62字符

=LOOKUP(99,FIND({"D","C","B","A"},UPPER(A2)&"D"),{"D","C","B","A"})
=MID(UPPER(A2&"D"),MIN(FIND({"A","B","C","D"},UPPER(A2&"DCBA"))),1)
=CHAR(6&MIN(IF(ISERR(FIND({"A","B","C"},UPPER(A2))),8,{5,6,7})))
=CHAR(6&MIN(IF(ISERR(SEARCH({"A","B","C"},A2&"D")),8,{5,6,7})))
=LOOKUP(99,SEARCH({"D","C","B","A"},A2&"D"),{"D","C","B","A"})

复制代码

zx_wl · 发表于 2014-2-17 09:14

本帖最后由 zx_wl 于 2014-2-24 10:14 编辑

=LOOKUP(,0/SEARCH({1;"C";"B";"A"},A2&1),{"D";"C";"B";"A"})
复制代码

江河行地 · 发表于 2014-2-17 10:12

本帖最后由江河行地于 2014-2-17 13:35 编辑

=MID("ABCD",MATCH(,0^SEARCH({"A","B","C","D"},A2&"D"),),1)

hongqiqqq · 发表于 2014-2-17 10:21

=LOOKUP(MIN(IF(MID(UPPER(A2),ROW(A$1:A$99),1)={"A","B","C"},{1,2,3},4)),{1,"A";2,"B";3,"C";4,"D"})

复制代码

三键回车
练练手，学习了

cleverzhzhf · 发表于 2014-2-17 11:09

先写一个规矩的，62字符：

复制代码

		自动登录	找回密码
密码			注册