Need help with script or formula
Solved/Closed
josh07429
Posts
14
Registration date
Friday June 23, 2017
Status
Member
Last seen
November 20, 2017
-
Updated on Jun 24, 2017 at 04:16 AM
josh07429 - Jul 5, 2017 at 12:18 PM
josh07429 - Jul 5, 2017 at 12:18 PM
Related:
- Need help with script or formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Ubuntu startup script - Guide
- Formula spreadsheet definition - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Jun 26, 2017 at 11:19 AM
Jun 26, 2017 at 11:19 AM
Hi Josh,
Give the following code a try:
Hope you like it.
Best regards,
Trowa
Give the following code a try:
Sub RunMe()
Dim x, y As Integer
y = 2
NewDate:
x = 0
If Range("B" & y) <> vbNullString Then
Range("C" & y).Value = Range("B" & y).Value
x = 1
End If
Do
If Range("A" & y) = Range("A" & y - 1) And _
Range("B" & y) <> vbNullString And _
x < 2 Then
Range("C" & y).Value = Range("B" & y).Value
x = x + 1
End If
y = y + 1
If Range("A" & y) <> Range("A" & y - 1) Then GoTo NewDate
Loop Until Range("A" & y) = vbNullString
End Sub
Hope you like it.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Jul 4, 2017 at 11:52 AM
Jul 4, 2017 at 11:52 AM
Hi Josh,
Quite the puzzle :)
See if the following code does the job:
Let me know how the code performs!
Best regards,
Trowa
Quite the puzzle :)
See if the following code does the job:
Sub RunMe()
Dim x, y, HighVal, SecHighVal, Rep As Integer
Dim mDate As Date
x = 2
y = 2
NextDate:
Do
mDate = Range("A" & x)
y = y + 1
Loop Until mDate <> Range("A" & y)
Range(Cells(x, "B"), Cells(y - 1, "B")).Select
HighVal = Application.WorksheetFunction.Max(Selection)
SecHighVal = Application.WorksheetFunction.Large(Selection, 2)
For Each cell In Selection
If cell.Value = HighVal And Rep < 2 Then
cell.Offset(0, 1).Value = cell.Value
Rep = Rep + 1
End If
Next cell
For Each cell In Selection
If cell.Value = SecHighVal And Rep < 2 Then
cell.Offset(0, 1).Value = cell.Value
Rep = Rep + 1
End If
Next cell
Rep = 0
If Range("A" & y).Value = vbNullString Then Exit Sub
x = y
GoTo NextDate
End Sub
Let me know how the code performs!
Best regards,
Trowa

Jun 26, 2017 at 12:56 PM
You're a life saver it worked :)
I only had a minor problem cause the dates have time but I just removed the time on the dates and your script works.
Thanks again.
Jun 27, 2017 at 02:29 PM