以下是引用那么的帅在2010-9-16 10:38:00的发言:
Private Sub Worksheet_Activate() Dim R With Sheets("数据") R = .Range("A65536").End(xlUp).Row a = 1 For x = 2 To R z = Application.CountIf(.Range("A2:A" & x), Range("A" & x)) If z = 1 Then Cells(a + 1, 1) = .Cells(x, 1) m = Application.Evaluate("=MAX((数据!$A$2:$A$" & R & "=A2)*(数据!$B$2:$B$" & R & "))") '=MAX((数据!$A$2:$A$11=A2)*(数据!$B$2:$B$11))这个引用数组应该怎么写? Cells(a + 1, 2) = m a = a + 1 End If Next x End With End Sub
结果不正确,是怎么回事?请指教。只得到第一个人的值 |