How to solve tie when using the Rank function?

S

Skeep

I am currently using the rank function and when a tie occurs they hav
the same rank.

So assume I have three months of sales that are the same... thei
ranking looks like this 1,1,1

I want it to rank the first occurence and then add 1 to each followin
rank that is the same so in this example it would return....1,2,3

I hope this is possible.

Thank
 
Top