2,462
社区成员
发帖
与我相关
我的任务
分享
Private Sub GetMax()
Dim i As Long
Dim tSheet As Worksheet
Dim sPrev As String
Dim sOrder As String
Dim Price As Single
Dim MaxP As Single
Set tSheet = ThisWorkbook.ActiveSheet
With tSheet
i = 1
sPrev = .Cells(i, 1)
MaxP = .Cells(i, 2)
While sPrev <> ""
sOrder = .Cells(i, 1)
Price = .Cells(i, 2)
If sOrder <> sPrev Then
Debug.Print
Debug.Print sPrev, MaxP
sPrev = sOrder
MaxP = Price
Else
If Price > MaxP Then
MaxP = Price
End If
End If
i = i + 1
Wend
End With
End Sub
hang = 4
lie = 1
Do While Sheet1.Cells(hang, lie).Value <> ""
Do While Sheet1.Cells(hang, 1).Value = Sheet1.Cells(hang + 1, 1).Value
If Sheet1.Cells(hang, 2).Value > Sheet1.Cells(hang + 1, 2).Value Then
Sheet1.Cells(hang + 1, 2).Value = Sheet1.Cells(hang, 2).Value
'Sheet1.Cells(hang, 2).Value = 0
Sheet1.Cells(hang, 2).Clear
Else
'Sheet1.Cells(hang, 2).Value = 0
Sheet1.Cells(hang, 2).Clear
End If
hang = hang + 1
Loop
hang = hang + 1
Loop