I have a giant database, and a number of formulas within in it. I've used
the formulas to calculate a total for each object and now I want to sort by
that total. When I do this, the formulas change. For example, for each item
I subtracted one of the numbers from the average for all of the items. To do
this I drug the formula down and then had to go back and use replace to
change all to subtract from that same number. When I try to sort, those
numbers that I used replace to change come back. I could just go down the
list and type each number in a cell next to it and use that, but I wanted to
hopefully find an easier way.