Excel

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

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