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)