Rank a value within a range

I need a function that will return the rank of a value within a range of a values, i.e. I have a named range with a numeric value in every cell. I want to parse the range and one of the cell values to a function and have the function return the rank of that value, i.e If the value is the smallest number in the range it returns 1, if the second smallest number in the range it returns 2, etc.

It also needs to handle duplicates, i.e. if the value is say, 10, there are three 10s in the range and 10 is the second smallest number in the range then the function returns 2 for the first 10, 3 for the next 10 and 4 for the third 10. It then returns 5 for the next value after 10.

My range is small,e.g. 32 numbers and only one column. Can anyone help?

Superb! I played with RANK but couldn't get it to do what I wanted. Thank you.

BTW, related to this is: I have a column of text values with duplicates. How can I find out if a value is the first (from the top) time it has appeared?

Cheers!

Damn! I just realised I stated it wrong. I want the duplicate values to be ranked the same, i.e. the rankings for the above would go 3,2,3,2,1.

I have a column of numeric values including duplicates.

d4: 11
d5: 8
d6: 8
d7: 11
d8: 3
d9: 5
d10: 3
d11: 6

copying RANK(D4,$D$4:$D$11,TRUE)+COUNTIF($D$4:D4,D4)-1 into e4:e11 i get results of 7,5,6,8,1,3,2,4.

But I am after 5,4,4,5,1,2,1,3, i.e. each duplicate is ranked the same with the sequence continuing afer the duplicate.

Looks like I need a function which uses RANK but I'm not too sure how.

Any help appreciated.