I want to sort data by the value of the formula.
The data is generated by a formula. I want to sort the data (and related rows) by the value of the formula output not the formula. I cannot do this.
I have created a new column. Using “paste special,” I have copied over the value derived from the formula. I can now sort the column based upon these values. However, the other columns (which contain names imported by formulae from another sheet) are not sorted correctly (that is, the content of the rows are no longer matched properly).