'学习改自 7楼 pengyx的方法
http://www.excelpx.com/thread-370343-1-1.html 7楼
Sub test()
i = [a65536].End(3).Row
f = Range("a2:a" & i)
z = Range("b2:b" & i)
ReDim ar(1 To UBound(z), 1 To 1)
For i = 1 To UBound(f)
For j = 1 To UBound(f)
If f(i, 1) = f(j, 1) Then
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'求一个儿子及后代的个数
temp = z(j, 1): k = 0: Child = 1
Do Until k > UBound(f) 'k > UBound(f),表示全部比较过
For k = 1 To UBound(z)
If temp = f(k, 1) Then
Child = Child + 1
temp = z(k, 1) '子变父
Exit For '回头
End If
Next k
Loop
ar(i, 1) = ar(i, 1) + Child '累计到该儿子的父里
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
End If
Next j
Next i
Range("c2").Resize(UBound(z), 1) = ar
End Sub
dg4.rar
(7.83 KB, 下载次数: 2)