Forum Discussion
davisgravel
Jan 09, 2024Copper Contributor
sorting numbers
I know almost nothing about excel, i'm trying to sort numbers in ascending order, left to right i have 5 columns of numbers and 1962 rows, can i sort multiple rows at one time? I can't even make it s...
peiyezhu
Jan 10, 2024Bronze Contributor
why does my first sort return to unsorted when i do a second sort?
Can you share some data and expected result for better understanding?
Can you share some data and expected result for better understanding?
- davisgravelJan 10, 2024Copper ContributorYour pic shows what I'm trying to do, I can sort one row at a time but when I do a second row my first row returns to an unsorted row.
- peiyezhuJan 10, 2024Bronze Contributor
=TRANSPOSE(SORT(TRANSPOSE(A1:C1)))
or online sql: