Index match?

A

amyylouise

New Member
Joined
Sep 3, 2013
Messages
22
I think I need an INDEX MATCH formula here but I just can't figure it out.

Sheet 1

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Payee (B)[/TD]
[TD]Amount (C)[/TD]
[TD]Date (D)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Payee 1[/TD]
[TD]130.08[/TD]
[TD]April 20, 2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Payee 2[/TD]
[TD]40.00[/TD]
[TD]April 21, 2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Payee 3[/TD]
[TD]131.25[/TD]
[TD]April 6, 2018[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Payee 4[/TD]
[TD]145.59[/TD]
[TD]April 29, 2018[/TD]
[/TR]
</tbody>[/TABLE]

-----
Sheet 2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Date (A)[/TD]
[TD]Payee (B)[/TD]
[TD]Amount (C)[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Start (E)[/TD]
[TD]End (F)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]20-Apr[/TD]
[TD]03-May[/TD]
[/TR]
</tbody>[/TABLE]

-----

OK, so if the date in column D of Sheet1 is between Sheet2 E1 and F1, I want that date entered into Sheet2 A1 and have the subsequent Payee and Amount details pulled as well.
Basically, I want the table A1:C3 to summarize all the bills due between the date range in E1:F1.

I hope this makes sense.

TIA!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes

Excel 2010
ABC
1Payee (B)Amount (C)Date (D)
2Payee 1130.084/20/2018
3Payee 2404/21/2018
4Payee 3131.254/6/2018
5Payee 4145.594/29/2018
Sheet1



Excel 2010
ABCDEF
1Datepayeeamount4/20/20185/3/2018
24/20/2018Payee 1130.08
34/21/2018Payee 240.00
44/29/2018Payee 4145.59
5   
6   
7   
8   
9   
10   
11   
Sheet2
Cell Formulas
RangeFormula
A2{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}
A3{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}
A4{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}
A5{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}
A6{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}
A7{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}
A8{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}
A9{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}
A10{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}
A11{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}
B2{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}
B3{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}
B4{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}
B5{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}
B6{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}
B7{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}
B8{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}
B9{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}
B10{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}
B11{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}
C2{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}
C3{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}
C4{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}
C5{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}
C6{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}
C7{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}
C8{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}
C9{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}
C10{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}
C11{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Scott T said:
Excel 2010
ABC
Payee (B)Amount (C)Date (D)
Payee 1
Payee 2
Payee 3
Payee 4

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]130.08[/TD]
[TD="align: right"]4/20/2018[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]40[/TD]
[TD="align: right"]4/21/2018[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]131.25[/TD]
[TD="align: right"]4/6/2018[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]145.59[/TD]
[TD="align: right"]4/29/2018[/TD]

</tbody>
Sheet1​



Excel 2010
ABCDEF
Datepayeeamount
Payee 1
Payee 2
Payee 4

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"]4/20/2018[/TD]
[TD="align: right"]5/3/2018[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]4/20/2018[/TD]

[TD="align: right"]130.08[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]4/21/2018[/TD]

[TD="align: right"]40.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]4/29/2018[/TD]

[TD="align: right"]145.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A2[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A2)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A2))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A3[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B3[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C3[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A3)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A3))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A4[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B4[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C4[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A4)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A4))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A5[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B5[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C5[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A5)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A5))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A6[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B6[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C6[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A6)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A6))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B7[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C7[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A7)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A7))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A8[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B8[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C8[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A8)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A8))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B9[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C9[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A9)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A9))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A10[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C10[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A10)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A10))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A11[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!C$2:C$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B11[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C11[/TH]
[TD="align: left"]{=IF(ROWS(A$2:A11)>COUNTIFS(Sheet1!$C$2:$C$5,">="&Sheet2!$E$1,Sheet1!$C$2:$C$5,"<="&Sheet2!$F$1),"",INDEX(Sheet1!B$2:B$5,SMALL(IF(Sheet1!$C$2:$C$5>=Sheet2!$E$1,IF(Sheet1!$C$2:$C$5<=Sheet2!$F$1,ROW(Sheet1!$C$2:$C$5)-ROW(Sheet1!$C$2)+1)),ROWS(A$2:A11))))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Thanks! :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Using index and match from another source excel file
2
Replies
10
Views
708
Peter_SSs
Peter_SSs
J
  • Question Question
Calculation based on value in table based on date range
Replies
0
Views
286
jsand
J
S
  • Question Question
Horizontal Return
Replies
6
Views
230
Fluff
Fluff
D
  • Question Question
Remove matching rows with pause function
Replies
1
Views
188
alansidman
alansidman
Drrellik
  • Solved
VBA to complete Index/Match with 2 criteria
2
Replies
10
Views
476
Alex Blakenburg
A

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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