Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
Have you tried to use the SORT formula? Perhaps you can share a doc with us? – Jacob Jan Tuinstra Dec 8 '13 at 12:54

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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