Sub d1()
Dim mrg As Range
x = Application.CountIf(Range("a:a"), Range("e1"))
Set mrg = Range("a1")
For y = 1 To x
Set mrg = Range("a:a").Find(Range("e1"), mrg) '解释这里,为什么保留mrg 结果结果E2=15.5
' Set mrg = Range("a:a").Find(Range("e1")) '解释这里,为什么删除mrg 结果E2=10
Next
Range("e2") = mrg.Offset(0, 1)