Using vba excel to find triplets with an exact difference

B

BRUCEWAYNE

New Member
Joined
May 15, 2019
Messages
7
HI5 folks,
i wish to find triplets of numbers with the difference of 11 within each row/line in the excel spreedsheet. three any numbers (x,y,z) whose difference is 11 , in other words z-y=11 , y-x=11. I use excel 2007. I tried it by using this code below:
Code: 
[COLOR=#660066][FONT=inherit]Sub[/FONT][/COLOR][COLOR=#000000][FONT=inherit] FIND1[/FONT][/COLOR][COLOR=#666600][FONT=inherit]()[/FONT][/COLOR]
[COLOR=#000000][FONT=inherit]     

    [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Option[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Explicit[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
     
    
        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Dim[/FONT][/COLOR][COLOR=#000000][FONT=inherit] lngRow  [/FONT][/COLOR][COLOR=#660066][FONT=inherit]As[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Long[/FONT][/COLOR][COLOR=#000000][FONT=inherit] 
        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Dim[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol  [/FONT][/COLOR][COLOR=#660066][FONT=inherit]As[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Integer[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
     
        lngRow [/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Do[/FONT][/COLOR][COLOR=#660066][FONT=inherit]While[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Not[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#008800][FONT=inherit]""[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
            [/FONT][/COLOR][COLOR=#660066][FONT=inherit]For[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#660066][FONT=inherit]To[/FONT][/COLOR][COLOR=#006666][FONT=inherit]4[/FONT][/COLOR][COLOR=#000000][FONT=inherit] 
                [/FONT][/COLOR][COLOR=#660066][FONT=inherit]If[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Abs[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]-[/FONT][/COLOR][COLOR=#000000][FONT=inherit] _
                    [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#666600][FONT=inherit]))[/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#006666][FONT=inherit]11[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Then[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
                    [/FONT][/COLOR][COLOR=#660066][FONT=inherit]If[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Abs[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]-[/FONT][/COLOR][COLOR=#000000][FONT=inherit] _
                        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]2[/FONT][/COLOR][COLOR=#666600][FONT=inherit]))[/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#006666][FONT=inherit]11[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Then[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
                        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]7[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#000000][FONT=inherit] _
                            [/FONT][/COLOR][COLOR=#008800][FONT=inherit]"("[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#008800][FONT=inherit]", "[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#000000][FONT=inherit] _
                            [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#008800][FONT=inherit]", "[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#000000][FONT=inherit] _
                            [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Cells[/FONT][/COLOR][COLOR=#666600][FONT=inherit]([/FONT][/COLOR][COLOR=#000000][FONT=inherit]lngRow[/FONT][/COLOR][COLOR=#666600][FONT=inherit],[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]2[/FONT][/COLOR][COLOR=#666600][FONT=inherit])[/FONT][/COLOR][COLOR=#666600][FONT=inherit]&[/FONT][/COLOR][COLOR=#008800][FONT=inherit]")"[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
                    [/FONT][/COLOR][COLOR=#660066][FONT=inherit]End[/FONT][/COLOR][COLOR=#660066][FONT=inherit]If[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
                [/FONT][/COLOR][COLOR=#660066][FONT=inherit]End[/FONT][/COLOR][COLOR=#660066][FONT=inherit]If[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
            [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Next[/FONT][/COLOR][COLOR=#000000][FONT=inherit] intCol
            lngRow [/FONT][/COLOR][COLOR=#666600][FONT=inherit]=[/FONT][/COLOR][COLOR=#000000][FONT=inherit] lngRow [/FONT][/COLOR][COLOR=#666600][FONT=inherit]+[/FONT][/COLOR][COLOR=#006666][FONT=inherit]1[/FONT][/COLOR][COLOR=#000000][FONT=inherit]
        [/FONT][/COLOR][COLOR=#660066][FONT=inherit]Loop[/FONT][/COLOR][COLOR=#660066][FONT=inherit]End[/FONT][/COLOR][COLOR=#660066][FONT=inherit]Sub[/FONT][/COLOR]


this code did the calculation only for some rows of input data posted bellow. It didn't do the calculation until the end of input data, it seems to stop in the middle of of input data and it's omiting some results . For example, it didn't show one the results (27,38,49) such as from the input data [TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 64"]10[/TD]
[TD="class: xl66, width: 64"]27[/TD]
[TD="class: xl66, width: 64"]38[/TD]
[TD="class: xl66, width: 64"]40[/TD]
[TD="class: xl66, width: 64"]49[/TD]
[TD="class: xl66, width: 64"]55[/TD]
[/TR]
</tbody>[/TABLE]


i used as general input data the list bellow:
Code: 
[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 64"][TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 64"]10[/TD]
[TD="class: xl66, width: 64"]27[/TD]
[TD="class: xl66, width: 64"]38[/TD]
[TD="class: xl66, width: 64"]40[/TD]
[TD="class: xl66, width: 64"]49[/TD]
[TD="class: xl66, width: 64"]55[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
8            11           22          33           44          55
[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl66, width: 64"]78[/TD]
[TD="class: xl66, width: 64"]88[/TD]
[TD="class: xl66, width: 64"]89[/TD]
[TD="class: xl66, width: 64"]90[/TD]
[TD="class: xl66, width: 64"]95[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]64[/TD]
[TD="class: xl67, width: 64"]76[/TD]
[TD="class: xl67, width: 64"]82[/TD]
[TD="class: xl67, width: 64"]84[/TD]
[TD="class: xl67, width: 64"]93[/TD]
[TD="class: xl67, width: 64"]97[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]67[/TD]
[TD="class: xl66, width: 64"]74[/TD]
[TD="class: xl66, width: 64"]79[/TD]
[TD="class: xl66, width: 64"]85[/TD]
[TD="class: xl66, width: 64"]91[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]64[/TD]
[TD="class: xl67, width: 64"]67[/TD]
[TD="class: xl67, width: 64"]78[/TD]
[TD="class: xl67, width: 64"]83[/TD]
[TD="class: xl67, width: 64"]93[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]73[/TD]
[TD="class: xl66, width: 64"]87[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]73[/TD]
[TD="class: xl67, width: 64"]74[/TD]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]76[/TD]
[TD="class: xl67, width: 64"]80[/TD]
[TD="class: xl67, width: 64"]93[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]73[/TD]
[TD="class: xl66, width: 64"]85[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]94[/TD]
[TD="class: xl66, width: 64"]97[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]83[/TD]
[TD="class: xl67, width: 64"]84[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[TD="class: xl67, width: 64"]99[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]69[/TD]
[TD="class: xl66, width: 64"]70[/TD]
[TD="class: xl66, width: 64"]73[/TD]
[TD="class: xl66, width: 64"]77[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]79[/TD]
[TD="class: xl67, width: 64"]81[/TD]
[TD="class: xl67, width: 64"]86[/TD]
[TD="class: xl67, width: 64"]87[/TD]
[TD="class: xl67, width: 64"]95[/TD]
[TD="class: xl67, width: 64"]98[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]78[/TD]
[TD="class: xl66, width: 64"]79[/TD]
[TD="class: xl66, width: 64"]83[/TD]
[TD="class: xl66, width: 64"]87[/TD]
[TD="class: xl66, width: 64"]93[/TD]
[TD="class: xl66, width: 64"]94[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]56[/TD]
[TD="class: xl67, width: 64"]63[/TD]
[TD="class: xl67, width: 64"]65[/TD]
[TD="class: xl67, width: 64"]81[/TD]
[TD="class: xl67, width: 64"]88[/TD]
[TD="class: xl67, width: 64"]89[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]79[/TD]
[TD="class: xl66, width: 64"]82[/TD]
[TD="class: xl66, width: 64"]84[/TD]
[TD="class: xl66, width: 64"]88[/TD]
[TD="class: xl66, width: 64"]91[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]76[/TD]
[TD="class: xl67, width: 64"]81[/TD]
[TD="class: xl67, width: 64"]83[/TD]
[TD="class: xl67, width: 64"]85[/TD]
[TD="class: xl67, width: 64"]86[/TD]
[TD="class: xl67, width: 64"]97[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]54[/TD]
[TD="class: xl66, width: 64"]65[/TD]
[TD="class: xl66, width: 64"]73[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]94[/TD]
[TD="class: xl66, width: 64"]97[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]59[/TD]
[TD="class: xl67, width: 64"]63[/TD]
[TD="class: xl67, width: 64"]73[/TD]
[TD="class: xl67, width: 64"]78[/TD]
[TD="class: xl67, width: 64"]91[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]78[/TD]
[TD="class: xl66, width: 64"]79[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]96[/TD]
[TD="class: xl66, width: 64"]97[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]85[/TD]
[TD="class: xl67, width: 64"]91[/TD]
[TD="class: xl67, width: 64"]92[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[TD="class: xl67, width: 64"]97[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]82[/TD]
[TD="class: xl66, width: 64"]86[/TD]
[TD="class: xl66, width: 64"]94[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]72[/TD]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]84[/TD]
[TD="class: xl67, width: 64"]90[/TD]
[TD="class: xl67, width: 64"]93[/TD]
[TD="class: xl67, width: 64"]97[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]75[/TD]
[TD="class: xl66, width: 64"]77[/TD]
[TD="class: xl66, width: 64"]89[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]97[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]84[/TD]
[TD="class: xl67, width: 64"]85[/TD]
[TD="class: xl67, width: 64"]93[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[TD="class: xl67, width: 64"]95[/TD]
[TD="class: xl67, width: 64"]100[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]60[/TD]
[TD="class: xl66, width: 64"]64[/TD]
[TD="class: xl66, width: 64"]77[/TD]
[TD="class: xl66, width: 64"]78[/TD]
[TD="class: xl66, width: 64"]89[/TD]
[TD="class: xl66, width: 64"]99[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]59[/TD]
[TD="class: xl67, width: 64"]66[/TD]
[TD="class: xl67, width: 64"]75[/TD]
[TD="class: xl67, width: 64"]86[/TD]
[TD="class: xl67, width: 64"]94[/TD]
[TD="class: xl67, width: 64"]95[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]88[/TD]
[TD="class: xl66, width: 64"]92[/TD]
[TD="class: xl66, width: 64"]93[/TD]
[TD="class: xl66, width: 64"]94[/TD]
[TD="class: xl66, width: 64"]95[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]53[/TD]
[TD="class: xl67, width: 64"]66[/TD]
[TD="class: xl67, width: 64"]78[/TD]
[TD="class: xl67, width: 64"]81[/TD]
[TD="class: xl67, width: 64"]88[/TD]
[TD="class: xl67, width: 64"]92[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]75[/TD]
[TD="class: xl66, width: 64"]82[/TD]
[TD="class: xl66, width: 64"]84[/TD]
[TD="class: xl66, width: 64"]86[/TD]
[TD="class: xl66, width: 64"]91[/TD]
[TD="class: xl66, width: 64"]98[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"]67[/TD]
[TD="class: xl67, width: 64"]68[/TD]
[TD="class: xl67, width: 64"]73[/TD]
[TD="class: xl67, width: 64"]85[/TD]
[TD="class: xl67, width: 64"]89[/TD]
[TD="class: xl67, width: 64"]96[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]84[/TD]
[TD="class: xl66, width: 64"]85[/TD]
[TD="class: xl66, width: 64"]86[/TD]
[TD="class: xl66, width: 64"]87[/TD]
[TD="class: xl66, width: 64"]93[/TD]
[TD="class: xl66, width: 64"]96[/TD]
[/TR]
</tbody>[/TABLE]



Can someone help me?

Many Thanks
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Hi BM

See if this helps


Code: 
Sub Test()
Dim vArr As Variant
Dim lRow As Long, j As Long, k As Long, l As Long, lOff As Long

lRow = 1
Do While Cells(lRow, "A") <> ""
    vArr = Application.Index(Range(Cells(lRow, "A"), Cells(lRow, "E")).Value, 0)
    lOff = 0
    For j = 1 To 3
       For k = j + 1 To 4
           For l = k + 1 To 5
               If vArr(k) - vArr(j) = 11 And vArr(l) - vArr(k) = 11 Then
                   Range("G" & lRow).Offset(0, lOff).Value = "("  & vArr(j) & "," & vArr(k) & "," & vArr(l) & ")"
                   lOff = lOff + 1
                End If
            Next l
        Next k
    Next j
    lRow = lRow + 1
Loop

End Sub


<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >F</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >G</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >H</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >I</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >J</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">21</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">32</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">35</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">40</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(10,21,32)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">23</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">29</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">40</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(18,29,40)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">24</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">27</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">31</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">35</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(13,24,35)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">14</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">18</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">22</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">26</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">11</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">15</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">22</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">33</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">44</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(11,22,33)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(22,33,44)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">20</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">31</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">42</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">53</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(20,31,42)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(31,42,53)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">16</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">27</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">38</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">49</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">60</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(16,27,38)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(27,38,49)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">(38,49,60)</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>8</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=11 style="background:#9CF; padding-left:1em" > [Book1]Sheet4</td></tr></table>
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Replace vlookup using Array and dictionary
Replies
8
Views
116
JEC
JEC
K
  • Question Question
conditional formatting question
Replies
2
Views
603
kerm007
K
edge37
  • Solved
Extract a list of names and averages from a table but observing certain attributes.
2
Replies
11
Views
95
Fluff
Fluff
O
  • Question Question
Add numbers backwards cumulatively until certain threshold is found
Replies
3
Views
595
KRice
K
welshgasman
  • Solved
Have chart show each row of data?
Replies
2
Views
64
welshgasman
welshgasman

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top