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).

  • Have you tried to use the SORT formula? Perhaps you can share a doc with us?
    – Jacob Jan
    Dec 8, 2013 at 12:54

1 Answer 1


There is not normally any difference between sorting on values as such or sorting on the results of formulae. Column A shows the result of applying weekday to the chronologically entered values in ColumnB. D:E is a copy of A:B but sorted on Column D ascending.

WA52638 example

There may be issues however with certain formulae that use the likes of Row() or offset, in which case it would help if your Q specified or gave an example of such formulae.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.