Forum Discussion
sortby
As far as i can work out "sortby" can only use 2 sort arrays, but i need to use 3 sort arrays, does anyone know if this is possible with Sortby
Thanks but excel 365 will NOT let me go beyond [using your example] column K, it will not permit me to add M and N it gives me the message "you can't change part of an array", i have set out my formula just as you have done but get that message thus not allowing me to go beyond two arrays to sort.
Try deleting the formula from the range first, then enter it anew.
- i did that, initially it would not work, however since i closed down the spreadsheet re-opened it and retyped the formula it has worked - thanks for your input!