Need an alternative to lots of nested IF statements

I found it. =SUM(IF(D22<$D$22:$D$45,1/COUNTIF($D$22:$D$45,$D$22:$D$45)))+1 Ctrl+Shift+Enter

It was at http://www.excelforum.com/excel-work...s-in-rank.html

Thanks for the help! You got me searching differently.