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))
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]CA[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]CO[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]
=INDEX($C$5:$C$58,MATCH(ROWS(S$5:$T5),$T$5:$T$58,0))
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]CA[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]CO[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]