I have a data set and I want to Rank Duplicate Values Sequentially without using an array function. Here is an example that I'm trying to achieve.

Region-Value-Rank
East-20-3
West-30-2
North-35-1
South-20-4
Central-15-5
Midwest-10-6

It does not matter if East gets 4 and South gets 3. I just want them to return different ranks rather than same.

Regards,
Kalyan Verma