=IF(COUNT(FIND(J1,A1:H3))>=1,"相同","不同")三键结束
在K1单元格输入=IF(COUNTIF(A1:H3,J1)>0,"相同","不同")
在k1输入公式 =if(countif(a1:h3,j1)>0,j1,"")
在K1中输入=IF(COUNTIF(A1:H3，J1),JI,"")
