I have created a ranking sheet for sales performance that automatically ranks
based on sales numbers. The rank formula works fine, but when ever I try to
sort the data based on the numeric ranking the formula in the column loses
its integrity.