Jul 29 2021 05:12 AM
Hi,,
I have trimmed my numbers and the sorting still wouldn't work. Sheet 3
Jul 29 2021 05:24 AM
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?
Jul 30 2021 05:59 AM
Jul 30 2021 06:06 AM
Shouldn't that be a single number?
Jul 30 2021 06:40 AM
Jul 30 2021 06:54 AM
So you just need the formula in E2; you can delete the rest in that column.