I need to find a formula that determines the low of the number in a range

I need a way to find out how small is -2.69% in the column (ie is it 5th smallest or 3rd smallest)


2.38%
0.66%
-2.99%
-1.53%
-2.32%
0.49%
-6.55%
1.31%
-1.09%
0.75%
1.44%
-2.69%
-2.48%
-1.27%
0.08%
-0.17%
1.88%
0.79%
0.00%
-0.08%
-1.61%
2.74%
-4.76%
3.14%
-3.23%
1.77%
0.36%
0.31%
1.32%
0.48%
-1.45%
1.85%
0.77%
-0.43%
2.84%
-1.16%
1.11%
1.16%
-0.21%
2.64%
0.30%
2.72%
-1.54%
0.78%
1.04%
-0.81%
-2.81%
-2.45%
1.89%
-4.34%
-0.40%
1.69%
-0.95%
-2.23%
-0.31%
-0.11%
0.68%
-1.86%

I hope this makes sense.

Mark

JieJenn


Your solution was dead on.

I have one small issue that the column will need to be based on a calculation from other columns and the formula does not work in that context.

Mark

JieJenn,

Sorry but the sheet I was using already had formatting in the cell I was using so it returned an error. Once I cleared out the formatting it workes perfectly.