Forum Discussion
Wynton90
Jul 29, 2021Copper Contributor
not sorting in ascending order
Hi,, I have trimmed my numbers and the sorting still wouldn't work. Sheet 3
Wynton90
Jul 30, 2021Copper Contributor
It is to find the Euclidean distance between the Sales and Margin.
HansVogelaar
Jul 30, 2021MVP
Shouldn't that be a single number?
- Wynton90Jul 30, 2021Copper ContributorYes indeed, thks for spotting the mistake. I got misled because the formula actually gives numbers.
- HansVogelaarJul 30, 2021MVP
So you just need the formula in E2; you can delete the rest in that column.