Index/match producing #n/a error for duplicate ranks

[Lotus User]

Column A = List of properties
Column B = % participation in a program
Column C = rank based on % high to low (1= highest participation) =SUMPRODUCT(($B$36:$B$46>$B36)/COUNTIF($B$36:$B$46,$B$36:$B$46&""))+1
Column D = sorted rank(index match) with rank listed high to low =INDEX($A$36:$A$46,MATCH($N36,$C$36:$C$46,0))
Column E = index and match the % that goes with the high to low rank =INDEX($B$36:$B$46,MATCH($N36,$C$36:$C$46,0))
Column N = just a list of static numbers 1-11

Problem encountered when the rank # (ie the participation % is the same.) The #N/A is produced on the duplicates. How do I get column D and E to recognize the duplicates and list the 2nd duplicate and not produce an error. If you see from the data below, WPS and WSA are the properties that produce the #N/A error since their % participation is the same as another property and they are listed second.

Thanks!

Column A	Column B	Column C	Column D	ColumnE
WMB	19.00%	7	WWJ	62.0%
WPB	21.00%	6	WSS	42.0%
WSC	41.00%	3	WSC	41.0%
WSS	42.00%	2	WOK	40.0%
WPS	42.00%	2	WWP	32.0%
WTO	14.00%	8	WPB	21.0%
WWP	32.00%	5	WMB	19.0%
WWJ	62.00%	1	WTO	14.0%
WOK	40.00%	4	WBP	0.0%
WBP	0.00%	9	#N/A	#N/A
WSA	0.00%	9	#N/A	#N/A

<tbody>
</tbody>

<tbody>
</tbody>

 

[Aladin Akyurek]

In D36 control+shift+enter, not just enter, copy across to E36, and down:

=INDEX(A$36:A$46,SMALL(IF($C$36:$C$46=SMALL($C$36:$C$46,ROWS(D$36:D36)),ROW($C$36:$C$46)-ROW($C$36)+1),
SUM(IF(SMALL($C$36:$C$46,ROW($C$36:C36)-ROW($C$36)+1)=SMALL($C$36:$C$46,ROWS(D$36:D36)),1))))