 # not sorting in ascending order

Hi,,

I have trimmed my numbers and the sorting still wouldn't work. Sheet 3

6 Replies

# Re: not sorting in ascending order

Sorting works fine.

# Re: not sorting in ascending order

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?

# Re: not sorting in ascending order

It is to find the Euclidean distance between the Sales and Margin.

# Re: not sorting in ascending order

Shouldn't that be a single number?

# Re: not sorting in ascending order

Yes indeed, thks for spotting the mistake. I got misled because the formula actually gives numbers.

# Re: not sorting in ascending order

So you just need the formula in E2; you can delete the rest in that column.