Forum Discussion
Solved
excel in windows 10.
how to create a button that sorts by one column and then assigns an order in another column from one to 20.
- Hi, What do you mean by 'order from 1 to 20'? What is 1, what is 30? Kind regards Hans
I see that absolute references static arrays comes more and more handy.
Using CHOOSE allows to combine multiple dynamic arrays.
=SORT(CHOOSE({3\1\2}; Table1[Text]; Table1[Value]; Table1[Rank]))
Also noted that RANK is around for backwards compatibility.
Agreed