I have two ranges of data - here is the first:

-3%
-11%
-10%
-6%
-15%
98%
-16%
-11%
0%
-19%
-4%
-3%

I am able to successfully rank this range based on the absolute value of each data point using the following formula:

=SUMPRODUCT(--(ABS(A$1:A$12)>ABS(A1)))+1

Here's my second range:

#N/A
-6%
#N/A
#N/A
-9%
62%
-11%
-6%
-17%
-12%
#N/A
#N/A

I am able to rank this range and ignore the #N/A values using the following formula:

=IF(ISNA(B1),"",COUNTIF(B$1:B$12,">"&B1)+1)

The problem is that I need to also rank the second range based on absolute values and I can't figure out how to modify either formula to do it. Any suggestions?

TIA