Excel顶级高手,请帮我找几个公式！

显示全部楼层 · 2012-10-5 22:42:09

你的数据从第2行开始吧：C2输入=IF(COUNT(FIND(B2,A2)),"","D")D2输入=IF(COUNT(FIND(B2,A2)),"C","")均回车并向下填充（下拉）...

千问 · 2012-10-5 22:42:09

在c1输入:=if(count(find(b1,a1)),"","D")下拉填充同理在d1输入:=if(counta(a1:b1)=2,if(count(find(b1,a1)),"C",""),"")下拉填充...

千问 · 2012-10-5 22:42:09

在C一列里输入 =IF(B1=A1,"","D")在D一列里输入 =IF(A1=B1,"C","")这个可以做到B中与A中不同，在C中显示D，相同在D中显示C可是你说A列有两位数……我再试试好了。...

千问 · 2012-10-5 22:42:09

C1输入公式=IF(OR(--LEFT(A1,1)=B1,--RIGHT(A1,1)=B1),"","D")D1输入公式=IF(OR(--LEFT(A1,1)=B1,--RIGHT(A1,1)=B1),"C","")此二个公式下拉复制...

千问 · 2012-10-5 22:42:09

C1单元格==IF(OR(--(0&MID($A1,{1;2},1))=$B1),"","D")D2单元格==IF(OR(--(0&MID($A1,{1;2},1))=$B1),"C","")这个问题都并不难需要这么多分吗...