Identify each result using SMALL (including duplicates)

[IAMS]

I'm trying to rank items in columnB by their price in columnA (smallest to largest). I have trouble because it only shows the first item that is 1.1, not the second. Is there a way to fix this?

DATA RESULT FORMULA
1.1 A A =IF($A$2="","",VLOOKUP(SMALL($A$2:$B$6,1),$A$2:$B$6,2,FALSE))
1.2 B A =IF($A$2="","",VLOOKUP(SMALL($A$2:$B$6,2),$A$2:$B$6,2,FALSE))
1.4 C B =IF($A$2="","",VLOOKUP(SMALL($A$2:$B$6,3),$A$2:$B$6,2,FALSE))
1.8 D C =IF($A$2="","",VLOOKUP(SMALL($A$2:$B$6,4),$A$2:$B$6,2,FALSE))
1.1 E D =IF($A$2="","",VLOOKUP(SMALL($A$2:$B$6,5),$A$2:$B$6,2,FALSE))

It shows AABCD instead of AEBCD (or EABCD).

Any help appreciated. Thanks.

 

[danzon]

I always handle these with a helper column....

insert a column BEFORE your data....so that your numbers now start in cell B1 and your letters start in C1

in cell A1 enter and drag down

=B1+ROW()/1000


in cell D1 enter

=VLOOKUP(SMALL(A:A,ROW()),A:C,3,0) and drag down



we use the column A helper to make each B value insignificantly larger so that the VLOOKUP sees each as a unique value