RANK.EQ Help with possible duplicate values

[DRExcel515]

I have a bunch of formulas set up that bring in identifiers then a formula that brings in the percentage of the total value of a holding in column "F". In column "B" I was using the Rank.eq formula to rank the positions based on the value in column "F". The problem I ran into this month is that there were two sets of identical values in column "F", thus giving them the same ranking value. Is there a way to avoid this without changing the value of the data in column "F". I was thinking of using a =F+ROW()/1000000, but I really don't want to alter the % value in column "F" at all if I can help it. Any help would be much appreciated.

Thanks!

 

[VBA Geek]

Excel 2010
	B	C	D	E	F
1	ranking				values
2	9				1
3	5				5
4	6				4
5	8				2
6	4				7
7	1				9
8	2				9
9	3				9
10	7				3
Sheet6

Cell Formulas
Range	Formula
B2	=RANK.EQ(F2,$F$2:$F$10)+COUNTIFS(F$2:F2,F2)-1
B3	=RANK.EQ(F3,$F$2:$F$10)+COUNTIFS(F$2:F3,F3)-1
B4	=RANK.EQ(F4,$F$2:$F$10)+COUNTIFS(F$2:F4,F4)-1
B5	=RANK.EQ(F5,$F$2:$F$10)+COUNTIFS(F$2:F5,F5)-1
B6	=RANK.EQ(F6,$F$2:$F$10)+COUNTIFS(F$2:F6,F6)-1
B7	=RANK.EQ(F7,$F$2:$F$10)+COUNTIFS(F$2:F7,F7)-1
B8	=RANK.EQ(F8,$F$2:$F$10)+COUNTIFS(F$2:F8,F8)-1
B9	=RANK.EQ(F9,$F$2:$F$10)+COUNTIFS(F$2:F9,F9)-1
B10	=RANK.EQ(F10,$F$2:$F$10)+COUNTIFS(F$2:F10,F10)-1

 

[DRExcel515]

This works great! Thank you so much