There is no value in column C so I want to have column E come back blank.

[RVT]

Hello,

Looking for help with this one. I have used similar situations already on the spreadsheet that
we are trying to get up and running but for some reason in this case none of the previous
solves have worked in this situation.

I have left the worksheet free of formulas that have not worked to avoid the clutter.

Please see attached work sheet.

Thank you,
Richard

[Sam Capricci]

Change the formula to this...
=IF(COUNTIF($C$1:$C$15,C1)>1,RANK(B1,$B$1:$B$15,1)/100,"")

[Sam Capricci]

And this if you need it to get rid of the #N/As
=IFERROR(IF(COUNTIF($C$1:$C$15,C1)>1,RANK(B1,$B$1:$B$15,1)/100,""),"")

[Sam Capricci]

Last option, if you still want the zeros to appear but not the #N/As then change it to this...
=IFERROR(IF(COUNTIF($C$1:$C$15,C1)>1,RANK(B1,$B$1:$B$15,1)/100,0),"")
(unless i'm missing what you want.)