How to use Index to find all values greater than
<p>I've been researching my situation quite a bit, both on this site and others, with this being the closest to my problem/solution:   </p>

<p><a href="https://stackoverflow.com/questions/23941500/find-all-values-greater-or-equal-than-a-certain-value">Find all values greater or equal than a certain value</a></p>

<p>However, using that solution in my situation does not give me the correct results. I have a list of 83 names with penalties being given to each name. On a separate tab, I'd like to display the output of all names that have any penalty (>0).<br>
I only have four possible penalties, so if I need to reference them in the formula (match or lookup), that would be fine also.  Shortening and dummying the data, here is an example of what I have:  </p>

<pre><code>+----------+---------+
|  Name    | Penalty |
+----------+---------+
| Name 1   |    0    |
| Name 2   |    0    |
| Name 3   |    5    |
| Name 4   |    0    |
| Name 5   |    0    |
| Name 6   |    10   |
| Name 7   |    0    |
| Name 8   |    0    |
| Name 9   |    0    |
| Name 10  |    20   |
+----------+---------+
</code></pre>

<p>Using this formula, then <code>CSE</code> and drag down:</p>

<pre><code>=INDEX($R$4:$R$13,SMALL(IF($S$4:$S$13&gt;0,ROW($S$4:$S$13)),ROW(1:1)))
</code></pre>

<p>It gives me these results:</p>

<pre><code>+---------+
| Name 6  |
| Name 9  |
| #REF!   |
| #NUM!   |
| #NUM!   |
| #NUM!   |
| #NUM!   |
| #NUM!   |
| #NUM!   |
| #NUM!   |
+---------+
</code></pre>

<p>I'll be taking care of the errors by using an IFERROR and making them blank, but it's still not finding the correct names of those with penalty points >0  </p>

<p>edit:  Changing the last "ROW" part gives me different answers, so I think my problem lies there somehow, but I still don't know what to do with it.  That's supposed to be the "k" value of the "SMALL" function.</p>

<p>Any help is much appreciated. Thanks!</p>