Forum Discussion
not sorting in ascending order
Hi,, I have trimmed my numbers and the sorting still wouldn't work. Sheet 3
That's because of the formulas in column E.
E2 contains =SQRT(SUMXMY2(C2:C919,D2:D919))
E3 contains =SQRT(SUMXMY2(C3:C920,D3:D920))
...
E919 contains =SQRT(SUMXMY2(C919:C1836,D919:D1836))
So E2 will always be the largest value (it sums all data rows), and E919 will always be the smallest value (it sums only row 919).
What is the purpose of column E?
It is to find the Euclidean distance between the Sales and Margin.