Excel

=IF(ISERROR(VLOOKUP(D2,B$2:B$24,1,0)),"不重复","重复")  D列的值是否在B列2 - 24行出现    

 

=IF(ISBLANK(B1), "", B1&",")  B1无值的话,返回空白,有值的话在后加,

 

posted @ 2017-12-29 22:37  zhiqsyr  阅读(109)  评论(0编辑  收藏  举报