Ranking Function based on number of cells

hi,

I have a ranking function which ranks a cell based on a certain number using the following code:

{=SUMPRODUCT((C:C=C2)*(F:F=F2)*(N:N>N2))+1}

The problem is if a cell in column N has two instances which are the same for each of the three cells you will get the same rank number. Ill explain by trying to represent the output:

Column C Column F Column N ActiveCell (with formula)
D x 2 1
D x 3 3
D x 2 1
D y 6 1
E x 8 1

The 1st and 3rd ceels both have the lowest value and hence get a 1 and therefore the 2nd lowest value gets a 3. What I would like is a function which outputs based on number size and if both the same then the first instance gets a 1, the second instance a 2 and so on resulting in:

Column C Column F Column N ActiveCell (with formula)
D x 2 1
D x 3 3
D x 2 2
D y 6 1
E x 8 1

Can somebody please help as this is bugging me and I cant find a way around it.

Thanks,
Dave