Ranking Numbers with #N/A in List
<p>I am trying to rank numbers that also has #N/A in the list. I have seen suggestions on using countif but that method hasn't been so fruitful. One thought is that because the numbers/values in the list are being generated using a formula (in this case an index and iferror formula), Excel is unable to recognize the outputs as number values that can be ranked. I tried to change the formatting to be numbers but that has not worked so far. Here's the formula that's being used to generate the numbers that need to be ranked:</p>

<pre><code>={IFERROR(INDEX($BT$12:$BT$272,$BV13,COLUMNS($BW$12:BW13)),#N/A)}
</code></pre>

<p>And the outputs range anywhere 1950-2015 including a bunch of #N/A. Any ideas on how to rank these numbers?</p>