多嘴快影 发表于 2021-9-20 17:52:00

数字和文字对比。


先谢。先谢。先谢。

芭蕉桑 发表于 2021-9-28 02:46:15

=SUMPRODUCT(({1,2,3,4,5}=1)*1)
=SUMPRODUCT(COUNTIF(D8,"*"&TRIM(MID(SUBSTITUTE(C8,",",REPT(" ",99)),ROW($1:$10)*99-98,99))&",*"))
=SUMPRODUCT(COUNTIF(D12,"*"&TRIM(MID(SUBSTITUTE(C12,"，",REPT(" ",99)),ROW($1:$10)*99-98,99))&"，*"))

风泰理疗 发表于 2021-10-13 20:14:57

COUNTIF第一参数只能引用单元格区域。

乐透 发表于 2021-12-8 03:32:01

1
=MATCH(1,{1,2,3,4,5},)
2
=MATCH(1,MMULT(1-ISERR(FIND(","&ROW(1:19)&",",","&C8:D8&",")),{1;1}),)-1
3
=MATCH(,-FIND(MID(C12&1/17,ROW(1:19)*2-1,1),D12))
页: [1]
查看完整版本: 数字和文字对比。