Sub Test() For n = 2 To Range("D65536").End(xlUp).Row s = "" For r = 2 To Range("B65536").End(xlUp).Row If Range("D" & n) = Range("B" & r) Then s = s & Range("A" & r) & " " End If Next If s = "" Then Range("E" & n) = 0 Else Range("E" & n) = Left(s, Len(s) - 1) End If Next End Sub追问