第1个回答 2013-07-18
sheet1的e2输入=if(or(countif(sheet2!b:b,b2),countif(sheet3!b:b,b2)),"相同","")
sheet2的e2输入=if(or(countif(sheet1!b:b,b2),countif(sheet3!b:b,b2)),"相同","")
sheet3的e2输入=if(or(countif(sheet1!b:b,b2),countif(sheet2!b:b,b2)),"相同","")
公式下拉复制本回答被提问者和网友采纳