Dynamic Sort Formula (Multiple Columns)

[Krix]

Hi. Good day!

is there a way to create a dynamic Sort formula that will sort multiple columns that is based on selection?

I actually have a formula in a cell that makes this: "SORT(ToRank_List,{8,10,14,11,13}, -1)" the part {8,10,14,11,13} actually changes based on the selection that I have used. When I tried to use indirect it doesn't work and gives me error. Is there a way to make this work? or is there a better way on doing this?

Thank you so much!

[avk]

Suppose your data from "B2" to "B8"
in "C2"

Please Login or Register  to view this content.

ToRank_List = Name Manager [select range "B2" to "B8"]

[Krix]

Thank you for the reply and apologies for not explaining further.

I have a attached a file for the expected output.

In the attachment, column J can be changed based on the preference. In the attached file it shows that the sorting is based on total, score2, score3...
there will be times that this might change, so just wondering if it's possible to have the formula generated in cell M3 to be dynamic
and will base the sort order on the selection in column J

[bebo021999]

In M3 then drag down and accross:

Please Login or Register  to view this content.

[XLent]

I actually have a formula in a cell that makes this: "SORT(ToRank_List,{8,10,14,11,13}, -1)" the part {8,10,14,11,13} actually changes based on the selection that I have used. When I tried to use indirect it doesn't work and gives me error. Is there a way to make this work?

Replace the array constant with the range reference - so, per your sample, use: =SORT(A3:F12,K2:K6,-1)

please also update your profile to highlight you're using O365.

[Krix]

Hi @bebo0219999 thank you for your reply. I actually need something that auto fills that formula. Hence, I used SORT.

[bebo021999]

Hi @bebo0219999 thank you for your reply. I actually need something that auto fills that formula. Hence, I used SORT.

I would misunderstand, but my formula is dynamic, isn't it?

[Krix]

Hi @XLent, all good now. I actually tried that at first and gives me error if there's a blank. What I did is just nested ifs. Thank you for help!

Also, my profile is now updated thank you for reminding. :D