ç»ä½ å个VBAæã
Sub çé()
With ActiveSheet
a = .Range("A65536").End(xlUp).Row 'åå¾Aåææ°æ®çè¡æ°
b = .Range("B65536").End(xlUp).Row 'åå¾Båææ°æ®çè¡æ°
n = 1
For i = 1 To a
k = 0
For j = 1 To b
tmp1 = Left(.Cells(j, 2).Text, 1) 'åå¾è¦æ¥æ¾ç第ä¸ä¸ªå符
n1 = InStr(.Cells(i, 1).Text, tmp1) 'æ¯å¯¹ç¬¬ä¸æ¬¡ï¼å¦ææ¾å°ï¼n1ä¼å¤§äº0
tmp2 = Right(.Cells(j, 2).Text, 1) 'åå¾è¦æ¥æ¾ç第äºä¸ªå符
n2 = InStr(.Cells(i, 1).Text, tmp2) 'æ¯å¯¹ç¬¬äºæ¬¡ï¼å¦ææ¾å°ï¼n2ä¼å¤§äº0
If n1 And n2 Then 'å¦æn1ï¼n2é½ä¸çäº0ï¼é£ä¹è¡¨ç¤ºæ°æ®è¢«æ¾å°ï¼è¦åé¤æï¼æ以置k=0ï¼éåºfor循ç¯
k = 0
Exit For
Else 'n1,n2ä¸æä¸ä¸ªä¸º0ï¼è¡¨ç¤ºæ¾ä¸å°ï¼å°kç´¯å ï¼è¡¨ç¤ºè¯¥æ°ä¸éå
k = k + 1
End If
Next j
If k <> 0 Then 'å¦ækä¸çäº0 ï¼å°±å°è¯¥æ°åå°Dåã
.Cells(n, 4).NumberFormatLocal = "@"
.Cells(n, 4).Value = .Cells(i, 1).Value
n = n + 1
End If
Next i
End With
End Sub
温馨提示:答案为网友推荐,仅供参考