二區重複數據 找出 (13498)

K6:L6下拉{=INDEX(C:C,SMALL(IF(COUNTIF($G:$G,$C$6:$C$19),ROW($6:$19),99),ROW(A1)))&""

M6:M11=IF(K6="","",VLOOKUP(K6*1,G:H,2,))




留言