Forum Discussion
Sorting with formulas
I am not able to sort data which are results from formulas. Can someone tell me why is it not working to do a simple sorting?
Thank you for answering.
The third column has formulas that is giving those results. But when I am using the sort function, it does nothing. Every number is format as numbers, not text. I want to sort from the smallest to the highest number.
Are you working in a PivotTable?
Yes, I am working with pivot tables. I thought it was that, so I have used formulas getting the values from the pivot table, sort function did not work. So I have tried with a simple formulas like this one, not coming for the pivot table
As you can see, 60 is a formula. a are values and b are the results of 60 + each line of a. The sort function still did not work. I do the same in another sheet of the pivot table, then the sort is working. Why?
Perhaps you may share sample file?
