I am trying to rank states according to specific criteria. I am using the formula below to rank each state but I have many states with the same ranking. They are displayed as #N/A. Can anyone suggest a way to show all duplicates with the same ranking?
=INDEX($C$5:$C$58,MATCH(ROWS(S$5:$T5),$T$5:$T$58,0))
<tbody>
</tbody>
=INDEX($C$5:$C$58,MATCH(ROWS(S$5:$T5),$T$5:$T$58,0))
| CA | 1 |
| #N/A | 1 |
| #N/A | 1 |
| #N/A | 1 |
| #N/A | 1 |
| #N/A | 1 |
| #N/A | 1 |
| #N/A | 1 |
| CO | 9 |
<tbody>
</tbody>
