数字和文字对比。

多嘴快影

先谢。先谢。先谢。
对比求助1.rar (8.73 KB, 下载次数: 17)

2021-9-20 17:52 上传

点击文件名下载附件
对比求助1.rar

芭蕉桑

=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))&"，*"))

风泰理疗

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

乐透

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))