Rank lowest to highest with duplicate values

I have a spreadsheet of 10 employees (column A) with a data validation list of products (column b). I created two different formulas in columns C & D to extract all of the digits from the product names in column A in attempt to setup a rank formula from lowest to highest $ amount. The problem is employees can have two different products or the same, but the formulas view them the same (ie $500-$20 & $500-$40 - formula views them as 500). I am searching for a rank formula solution that can differentiate products that have the same dollar amounts.

Employee	Products	    Formula 1	  Formula 2	 Rank on formula 1	  Rank on formula 2
Employee A   Feet $500-$40	      500	    500-40	       1	                  3
Employee C   Feet $500-$40	      500	    500-40	       1	                  3
Employee C   Pontiac $500-$20	      500	    500-20	       1	                  2
Employee D   USA Feet $2,000-100%    2000	    2000-100	       2	                  1
Employee E   USA Feet $2,000-100%    2000	    2000-100	       2	                  1
Employee F   Pontiac $500-$20	      500	    500-20	       1	                  2
Employee G   Pontiac $500-$20	      500	    500-20	       1	                  2
Employee H   Feet $500-$40	      500	    500-40	       1	                  3

Desired Result:

Employee	Products	             Rank
Employee A	Feet $500-$40	              2
Employee B	Feet $500-$40	              2
Employee C	Pontiac $500-$20	      1
Employee D	USA Feet $2,000-100%	      3
Employee E	USA Feet $2,000-100%	      3
Employee F	Pontiac $500-$20	      1 
Employee G	Pontiac $500-$20	      1
Employee H	Feet $500-$40	              2