rank profit + sales is repeating if you see which is 10 and same goes with 33 , but it should get increase
10,11,12 and Original 12 will be changed to 13
Missed that part. I can't think of another solution.
I considered Prep, but that doesn't include RANK'ing (although you can create your own ranking functionality in Prep), but even then I am not sure if you can fulfill your requirement.
Another thought I had is to use TabPy. I have no experience for it myself, but it might be an option...