Creating Ranks in script for tied values and then skipping the next rank by Autonumber

[DKK]

Hi All

I was trying to creating the ranks  for the following data as follows but some how its not giving the right results by using Autonumber function. output required for ranks should be something like ( 1,2,2,4,5,6,6,8)  and attached is the excel file for reference. Any advise or help is highly appreciated

Regards

KD

[sugathirajkumar]

rank(sum(Amount))

[DKK]

Hi,

i don’t think we can use Rank() function in the script . Moreover my desired rank should be something liken1,2,2,4