Match problem

M

msmackenzie

New Member
Joined
Feb 11, 2011
Messages
9
I have a formula that looks like this: Match(0,A1:A20,1). The purpose is to find the first cell in the range (A1:A20) that has a number greater than 0.
This seems to work on most ranges but occasionally finds the wrong match.

All data in range is a number between 0 and 1.

Any help appreciated.
 
Sort by date Sort by votes
Here's how you would apply it to your formula...

=IF($A89<(INDEX($A$7:A$78,MATCH(1,1/(G$7:G$78>0),0),1))+52*7,"",SUM(OFFSET(G61,-51,0,52,1)))


Still entered with CTRL + SHIFT + ENTER
 
Upvote 0

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sorry jonno - I should have explained myself better.

I realise that the data needs to be in ascending order if I want to find the closest match - however I only want to find the first cell with data in it. I thought (wrongly it seems) that the match formula (with a match type 1) will look down an array in order until it finds a number higher than the lookup value - it will then stop looking any further and return the match number.

wrt row and position numbers - I understand this - it is the position number I want - the row numbers were just there to be helpful although in hindsight they were probably just confusing.
 
Upvote 0
Msmackenzie,

Look at your formula Adjusted by me.

OBS: Match finds the largest value that is less than or equal to lookup_value.

<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">6</TD><TD style="BACKGROUND-COLOR: #92d050">Item Position</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">6</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,09</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,97</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">24</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">36</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">29</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">35</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">27</TD><TD style="BACKGROUND-COLOR: #92d050">Line Position</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">24</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">36</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">29</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">35</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">27</TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,09</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,97</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">35</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">36</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">39</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">40</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">41</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #d8d8d8"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">42</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">43</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>**********</TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,A$1:A$20,1)+1</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,B$1:B$20,1)+1</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,C$1:C$20,1)+1</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,D$1:D$20,1)+1</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,E$1:E$20,1)+1</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F23</TH><TD style="TEXT-ALIGN: left">=ROW(A22)+MATCH(0,A$22:A$41,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G23</TH><TD style="TEXT-ALIGN: left">=ROW(B22)+MATCH(0,B$22:B$41,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H23</TH><TD style="TEXT-ALIGN: left">=ROW(C22)+MATCH(0,C$22:C$41,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I23</TH><TD style="TEXT-ALIGN: left">=ROW(D22)+MATCH(0,D$22:D$41,1)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J23</TH><TD style="TEXT-ALIGN: left">=ROW(E22)+MATCH(0,E$22:E$41,1)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Array Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(A$1:A$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(B$1:B$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(C$1:C$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(D$1:D$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(E$1:E$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F22</TH><TD style="TEXT-ALIGN: left">{=ROW(A22)+MATCH(TRUE,(A$22:A$41)>0,0)-1}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G22</TH><TD style="TEXT-ALIGN: left">{=ROW(B22)+MATCH(TRUE,(B$22:B$41)>0,0)-1}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H22</TH><TD style="TEXT-ALIGN: left">{=ROW(C22)+MATCH(TRUE,(C$22:C$41)>0,0)-1}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I22</TH><TD style="TEXT-ALIGN: left">{=ROW(D22)+MATCH(TRUE,(D$22:D$41)>0,0)-1}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J22</TH><TD style="TEXT-ALIGN: left">{=ROW(E22)+MATCH(TRUE,(E$22:E$41)>0,0)-1}</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>


Markmzz
 
Upvote 0
find the closest match
---
find the first cell with data in it

Those are 2 very different objectives.


When matchtype 1 is used, it does a binary search.
It does not go 1 cell at a time top to bottom looking for the closest match..

It actually Splits the array in half, and searches each half for a value larger than the lookup value.
Then splits that half in half, and repeats...
Untill it finds the smallest value that is greater than the lookup value.

this is why it must be sorted ascending.


Hope that helps..
 
Upvote 0
Msmackenzie,

Your formula has worked with the small adjustment which I did, because the initial ranges (from 0 to the first number greater than 0) were ordered in ascending order.

So, if you use 1 to match type argument of the Excel match function, o Excel searches (in the first interval) the largest value that is less than or equal to the value searched (the last 0).

If you use the -1 to the argument type of match match function will search for Excel (on the first range again) the smallest value that is greater than or equal to the value searched (the first 0).

Markmzz
 
Upvote 0
Yep, thanks mark.
I had the match types mixed up...

1 = largest value that is less than the lookup value - data must be sorted ascending.
-1 = smallest value that is greater than the lookup value - data sorted DEscending.
0 = exact match - data does not need to be sorted.
 
Upvote 0
Jonmo1,

Look for this behavior (in this specific case):


<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH><TH>I</TH><TH>J</TH><TH>K</TH><TH>L</TH><TH>M</TH><TH>N</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; COLOR: #ff0000; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">6</TD><TD style="BACKGROUND-COLOR: #92d050">Item Position</TD><TD style="FONT-WEIGHT: bold">Data Orders</TD><TD style="FONT-WEIGHT: bold">Behavior</TD><TD style="FONT-WEIGHT: bold">Find</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,40</TD><TD style="TEXT-ALIGN: right; COLOR: #0070c0; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">5</TD><TD style="COLOR: #0070c0; FONT-WEIGHT: bold">Type Match = +1</TD><TD style="COLOR: #0070c0; FONT-WEIGHT: bold">...,-2,-1,0,+1,+2,..., A,...,Z,False,True</TD><TD style="COLOR: #0070c0; FONT-WEIGHT: bold">Large - <=</TD><TD style="COLOR: #0070c0; FONT-WEIGHT: bold">Last zero</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,03</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,88</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">Type Match = -1</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">True,False,Z,...,A,...,+2,+1,0,-1,-2,...</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">Small - >=</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">First zero</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,05</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">1</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">Type Match = 0</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">No orders</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">Exact</TD><TD style="COLOR: #ff0000; FONT-WEIGHT: bold">First zero</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,97</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,80</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; COLOR: #0070c0; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,47</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,67</TD><TD style="TEXT-ALIGN: right; COLOR: #0070c0; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,26</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,54</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,04</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,28</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,38</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,02</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,52</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,19</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,81</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,16</TD><TD style="TEXT-ALIGN: right">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,56</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; COLOR: #0070c0; FONT-WEIGHT: bold">0,00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,79</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,70</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #92d050">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,76</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,09</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,01</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,61</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,63</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,29</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,37</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4">0,71</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #b8cce4"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD>******</TD><TD style="TEXT-ALIGN: center">**************</TD><TD style="TEXT-ALIGN: center">*******************************</TD><TD style="TEXT-ALIGN: center">**********</TD><TD style="TEXT-ALIGN: center">**********</TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,A$1:A$20,RIGHT($K2,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,B$1:B$20,RIGHT($K2,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,C$1:C$20,RIGHT($K2,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,D$1:D$20,RIGHT($K2,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J2</TH><TD style="TEXT-ALIGN: left">=MATCH(0,E$1:E$20,RIGHT($K2,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F3</TH><TD style="TEXT-ALIGN: left">=MATCH(0,A$1:A$20,RIGHT($K3,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G3</TH><TD style="TEXT-ALIGN: left">=MATCH(0,B$1:B$20,RIGHT($K3,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H3</TH><TD style="TEXT-ALIGN: left">=MATCH(0,C$1:C$20,RIGHT($K3,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I3</TH><TD style="TEXT-ALIGN: left">=MATCH(0,D$1:D$20,RIGHT($K3,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J3</TH><TD style="TEXT-ALIGN: left">=MATCH(0,E$1:E$20,RIGHT($K3,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F4</TH><TD style="TEXT-ALIGN: left">=MATCH(0,A$1:A$20,RIGHT($K4,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G4</TH><TD style="TEXT-ALIGN: left">=MATCH(0,B$1:B$20,RIGHT($K4,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H4</TH><TD style="TEXT-ALIGN: left">=MATCH(0,C$1:C$20,RIGHT($K4,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I4</TH><TD style="TEXT-ALIGN: left">=MATCH(0,D$1:D$20,RIGHT($K4,2))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J4</TH><TD style="TEXT-ALIGN: left">=MATCH(0,E$1:E$20,RIGHT($K4,2))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Array Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>F1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(A$1:A$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>G1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(B$1:B$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>H1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(C$1:C$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>I1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(D$1:D$20)>0,0)}</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>J1</TH><TD style="TEXT-ALIGN: left">{=MATCH(TRUE,(E$1:E$20)>0,0)}</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>


Markmzz
 
Upvote 0
Not sure I understand what point you're making.
Using 1 or -1 did not return the correct results needed by the OP (first value >0)

The bottom line is :
When using 1 as the match type, the data (the entire dataset in the referenced range) must be sorted ascending.
when using -1, it must be sorted Descending.

Otherwise, strange and seemingly random results occur.

Example, put a 0 in A10 and watch your formula in F2 change to 11.


Match uses a binary search when 1 or -1 are used for the match type.

See post #7 in this thread for a great explaination of Binary search by Aladin.
 
Upvote 0
jonmo1 said:
Not sure I understand what point you're making.
Using 1 or -1 did not return the correct results needed by the OP (first value >0)

The bottom line is :
When using 1 as the match type, the data (the entire dataset in the referenced range) must be sorted ascending.
when using -1, it must be sorted Descending.

Otherwise, strange and seemingly random results occur.

Example, put a 0 in A10 and watch your formula in F2 change to 11.


Match uses a binary search when 1 or -1 are used for the match type.

See post #7 in this thread for a great explaination of Binary search by Aladin.
Click to expand...

Jonmo1,

You're right. The results are very strange. I mistook the numbers.

Thank you.

Markmzz
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Find in VBA - unexpected behaviour
Replies
7
Views
153
MARK858
MARK858
K
  • Solved
MATCH for a value over a specific number
Replies
7
Views
220
Kaper
Kaper
G
  • Solved
Using the FIND and OFFSET functions, combined with the MATCH function in the one formula
Replies
8
Views
174
Peter_SSs
Peter_SSs
P
  • Solved
Hard Question - Chatbot failed with multpile attempts
Replies
3
Views
234
pban
P
C
  • Question Question
FIND does not pick up phrases unless its an exact match. As explained below
Replies
1
Views
93
JamesCanale
JamesCanale

Forum statistics

Threads
1,225,155
Messages
6,183,218
Members
453,152
Latest member
ChrisMd

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