发布网友 发布时间:2022-02-25 05:54
共2个回答
热心网友 时间:2022-02-25 07:23
vlookup公式热心网友 时间:2022-02-25 08:41
用公式:=IF(AND(SUM(COUNTIF(Sheet1!A:A,Sheet1!A1),COUNTIF(Sheet2!A:A,Sheet1!A1))>1,SUM(COUNTIF(Sheet1!B:B,Sheet1!B1),COUNTIF(Sheet2!B:B,Sheet1!B1))>1),"身份证与姓名均不同",IF(AND(SUM(COUNTIF(Sheet1!A:A,Sheet1!A1),COUNTIF(Sheet2!A:A,Sheet1!A1))>1,SUM(COUNTIF(Sheet1!B:B,Sheet1!B1),COUNTIF(Sheet2!B:B,Sheet1!B1))=1),"身份证相同,姓名不同",IF(AND(SUM(COUNTIF(Sheet1!A:A,Sheet1!A1),COUNTIF(Sheet2!A:A,Sheet1!A1))=1,SUM(COUNTIF(Sheet1!B:B,Sheet1!B1),COUNTIF(Sheet2!B:B,Sheet1!B1))>1),"身份证不同,姓名相同","身份证与姓名均相同")))。。。下拉填充,把填充的区域选上,在单击菜单的“格式”->“条件格式”,把“介于”改成“等于”,在旁边的输入框输入="身份证与姓名均不同",单击“格式”选一种字体颜色区分开来,再单击“添加”,按以上步骤,输入框的内容是