Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

1 Answer

There is not normally any difference between sorting on values as such or sorting on the results of formulae. Column B shows the result of applying weekday to the chronologically entered values in ColumnB. D:E is a copy of A:Bare copies 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
add comment

Your Answer

 
discard

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.