On a Mac. When I use the Sort function like this =SORT(A1:A10) It will sort any numbers in any combination from lowest to highest as I expected. It even puts the blanks at the bottom as 0.
But when I want to do the same thing here =SORT(A1:A10) it doesn't work. I tried =SORT(A1:A10,1,-1,1) and everything else and I can't get it to work. Why does the SORT function treat the array differently and how can I get it to work?
Thank you!
But when I want to do the same thing here =SORT(A1:A10) it doesn't work. I tried =SORT(A1:A10,1,-1,1) and everything else and I can't get it to work. Why does the SORT function treat the array differently and how can I get it to work?
Thank you!