Problem with SMALL function and multiple same values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a column with about 1000 distances in miles to a point and I am
trying to use the SMALL function to give me the closest, 2nd closest,
3rd closest, etc. The problem is some of the distances are exactly
the same. For example the SMALL function is returning the same
distance for the 2nd and 3rd distance which it should. However, when
using the CELL("Address") function to give me the exact address of the
cell that the SMALL function is returning I get the same cell address
for the 2nd and 3rd distances.

Example:
4.4
5.7
9.9
4.4
3.0
11.1
15.1

SMALL(A1:A7,1) = 3.0; then using the Cell(Address) function with Small
nested to return $A$5

the problem arises with the 2nd and 3rd
SMALL(A1:A7,2) = 4.4; then using the Cell(Address) function with Small
nested to return $A$1
SMALL(A1:A7,3) = 4.4; then using the Cell(Address) function with Small
nested to return $A$1....I was hoping that this would return$A$4

Can anyone suggest a fix for how I can get this to work? Thanks!

.

Relevant Pages