Rank lowest to highest with duplicate values

I probably should have been more clear in the original post, but yes the formula you supplied works great with how I laid out the information. All of the information in Column A can be mixed and matched. For instance, if I select the following values with the above formula:

                                                                  Rank      Desired Rank
USA Emboss. Orange $4,000-100%                                       5                     5
Orange $3,000-70% Treat ACE Free                                     4                     3
USA Emboss. Orange $3,000-80%                                        4                     4
Feet $500-$40                                                        2                     2
Pontiac $500-$20                                                     2                     1