excel请问如何判断2行单元格是否有字符相同
如何算出A行离包含有B行离的内容
=if(or(isnumber(find(d2,$a$2:$a$5))),"包含","不包含")
=IF(LEFT(B1,9)<=LEFT(A1,9),"","不")&"包含"
热门标签:
如何算出A行离包含有B行离的内容
=if(or(isnumber(find(d2,$a$2:$a$5))),"包含","不包含")
=IF(LEFT(B1,9)<=LEFT(A1,9),"","不")&"包含"