Forum Discussion
Solved
Complicated sorting
Hello I'm trying to sort some data, i have multiple columns that i want to use for the sort. I used the SORT function to sort by one column but then i want if 2 or more of the values are equal t...
bernidakis It will stay at the bottom, indeed. Just give it a try yourself. Otherwise play around with the attached file.
bernidakis If you have SORT you should also have SORTBY. The fist argument is the array you want to sort, followed by pairs of columns and sort order.
Something like this:
But if in line 4
name3 2 6
then will it go to the top or it will stay at bottom as it should?
name3 2 6
then will it go to the top or it will stay at bottom as it should?
bernidakis It will stay at the bottom, indeed. Just give it a try yourself. Otherwise play around with the attached file.
- Tried it and worked perfectly! Thanks a lot!!!!