Why not simply use:
=IF(A1="","",RANK(A1,A$1:A$12,1))

And copy down.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jennifer" wrote:

I am using the below formula to rank a column. I want whoever has the lowest
number to be ranked #1 and so forth. Any suggestions?

=IF(A1="","",SUMPRODUCT(--(A1<A$1:A$12),1/COUNTIF(A$1:A$12,A$1:A$12&""))+1)