I'm trying to rank the values in cells S32:S38 in ascending order while ignoring zeros and negative values. I also need to rank duplicate values with a unique ranking, so that no ranking value is repeated. I tried the formula below, but the ranking values start at "2" instead of "1" and I can't figure out how to fix it. Any ideas?
Thanks
Formula:
=IF(S32<=0,"N/A",RANK(S32,$S$32:$S$38,1)+COUNTIF($S$32:S32,S32)-1)
Bookmarks