Home |
Search |
Today's Posts |
#26
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Vergel Adriano,
Out of interest was do the variables i & j actually do please. 'FindTriplets lRow = 2 For Each c In rng If c.Column <= 5 Then For i = 1 To 6 - c.Column For j = 1 To 6 - c.Offset(0, i).Column strTriplet = c.Value & "_" & c.Offset(0, i).Value & "_" & c.Offset(0, i + j).Value On Error Resume Next lRow2 = Application.WorksheetFunction.Match(strTriplet, wsResult.Range("E:E"), False) If Err.Number 0 Then wsResult.Range("E" & lRow).Value = strTriplet wsResult.Range("F" & lRow).Value = c.Value wsResult.Range("G" & lRow).Value = c.Offset(0, i).Value wsResult.Range("H" & lRow).Value = c.Offset(0, i + j).Value wsResult.Range("I" & lRow).Value = 1 lRow = lRow + 1 Else wsResult.Range("I" & lRow2).Value = wsResult.Range("I" & lRow2).Value + 1 End If On Error GoTo 0 Next j Next i End If Next c End If Thanks in Advance. All the Best. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find the most common numbers? | New Users to Excel | |||
From 2 rows or column how to find common numbers | Excel Discussion (Misc queries) | |||
count and return pair numbers | Excel Worksheet Functions | |||
Need code to pair off numbers | Excel Programming | |||
in excel, how do I find which value doesn't have a pair? | Excel Discussion (Misc queries) |