Hi, I have a macro that goes through and identifies items to be grouped together, and it is a for loop. I am trying to assign an ID to the group, but what I have only works for groups with two items. Any ideas on how to code it to handle larger groups? Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Assigning an ID
- Thread starter denisem95
- Start date
Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,459
- Office Version
- 365
- Platform
- Windows
Show the code
Upvote
0
Code:
Sub Cluster_Find() For i = 2 To 12
Temp = i
For h = i + 1 To 13
If Cells(h, 19).Value >= Cells(i, 19).Value Then
If Cells(h, 19).Value <= Cells(i, 22).Value Then
If Cells(h, 20).Value >= Cells(i, 23).Value Then
If Cells(h, 20).Value <= Cells(i, 24).Value Then
Cells(i, 25).Value = Temp
Cells(h, 25).Value = Temp
Else
End If
Else
If Cells(h, 21).Value >= Cells(i, 23).Value Then
If Cells(h, 21).Value <= Cells(i, 24).Value Then
Cells(i, 25).Value = Temp
Cells(h, 25).Value = Temp
Else
End If
Else
End If
End If
Else
End If
Else
End If
Next h
Next i
End Sub
Upvote
0
