Definitely use Rank! Works with sort on. Do not need Row ID either. Use the column that you’ve sorted with in the formula. Only caveat is: duplicate values will return duplicate visual position result. To be expected though. See the screenshot. NOW, if anyone can help me offline with the Running Bal column!
