excel两列对比

=IF(ISERROR(VLOOKUP(A1,C:C,1,0)),"NO","Y")


=IF(A1=B1,"y","n")



=IF(CONCATENATE(A2,B2,C2,D2)=CONCATENATE(F2,G2,H2,I2),"y","n")


判断为空=isblank(),返回true或者false



找出同一列的重复数据

=IF(COUNTIF(A:A,A2)>1,"重复","")

posted @ 2022-09-23 18:03  silentmuh  阅读(57)  评论(0)  编辑  收藏  举报
Live2D