Sort List in Ascending Order Using Only Excel Tokens [hard puzzle]

[curiousXcel]

Somebody might be interested, this is not an easy task. It asks to sort a list using only excel formulas, but not a sort. So you have to use array calculation knowledge and so on.
https://www.homeworkhelponline.net/blog/programming/excel-puzzle

 

[Eric W]

I guess it depends on what you call easy. If you have the new array formulas, it would just be:

=SORT(C5:C10)

Can't get much easier. But those aren't widely available yet. Yes, there are ways to dynamically sort a list in Excel with current functions. You can find many places that explain them, including several threads on this forum. Try Googling "Excel dynamic sort formula character". There are several versions.