优质解答
你的数据不规范,不利于查找,如假定A1数据是“1,4,5,8,12“,要查找是否有“2,3”,从A1中能查到2,但实际A1中是12,并不是你想要的.为能做到完全匹配,建议格式改成“,1,2,3,8,10,"这样的,公式如下
C1: =ABS(2-(ISERROR(FIND(","&LEFT(B1,FIND(",",B1)),A1))+ISERROR(FIND(MID(B1,FIND(",",B1),LEN(B1)-FIND(",",B1)+1)&",",A1))))
你的数据不规范,不利于查找,如假定A1数据是“1,4,5,8,12“,要查找是否有“2,3”,从A1中能查到2,但实际A1中是12,并不是你想要的.为能做到完全匹配,建议格式改成“,1,2,3,8,10,"这样的,公式如下
C1: =ABS(2-(ISERROR(FIND(","&LEFT(B1,FIND(",",B1)),A1))+ISERROR(FIND(MID(B1,FIND(",",B1),LEN(B1)-FIND(",",B1)+1)&",",A1))))